Explain MySQL architecture?



Explain MySQL architecture?..

Answer / amith

The front layer takes care of network connections and
security authentications, the middle layer does the SQL
query parsing, and then the query is handled off to the
storage engine.

A storage engine could be either a default one supplied
with MySQL (MyISAM) or a commercial one supplied by a third-
party vendor (ScaleDB, InnoDB, etc.)

Is This Answer Correct ?    18 Yes 3 No

Post New Answer

More MySQL Interview Questions

What are the advantages of MySQL when compared with Oracle?

0 Answers  


Where MyISAM table will be stored and also give their formats of storage?

0 Answers  


How do you start MySQL on Linux?

5 Answers   Cybernet,


How to use in conditions?

0 Answers  


Can you tell which of the following where clauses is faster?

0 Answers  






Why mysql is so popular?

0 Answers  


What is the use of concat() in mysql?

0 Answers  


How to show certain selected rows with the value "pcds".

0 Answers  


What is MySQL Stored Procedure?

1 Answers  


What is dirty read and phantom read?

0 Answers  


How do I transfer data from one database to another in mysql?

0 Answers  


Is mysql port 3306 tcp or udp?

0 Answers  


Categories