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 is the maximum number of columns per table?

0 Answers  


What is the difference between a heap table and temporary table?

0 Answers  


How do I find users in mysql?

0 Answers  


What is the maximum connection pool size?

0 Answers  


What is key in mysql?

0 Answers  






What is sql in mysql?

0 Answers  


How do I clear the screen in mysql?

0 Answers  


What is the difference between primary and unique key

5 Answers   CSC,


What is mysql server used for?

0 Answers  


What is prepared statement in mysql?

0 Answers  


What are the limitations of mysql?

0 Answers  


How much does mysql cost?

0 Answers  


Categories