Explain MySQL architecture?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is text?

562


Explain about reporting services of MYSQL?

612


What is blob storage?

502


What are the 'mysql' command line arguments?

531


What is a storage engine?

561






What are the three types of queries?

461


What causes mysql too many connections?

482


How do stored procedures work?

488


What is the latest version of php and mysql?

679


What is horizontally scalable?

512


What is mysql server?

490


Which command is used to view the content of the table in mysql?

500


How to calculate the difference between two dates?

486


What is mysql_connect?

513


What are stored procedures and functions?

476