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 are the method you will follow while sql installing

1864


How can I change database in mysql?

446


What is blob in mysql?

485


What is the current root password of mysql?

481


What is row?

559






How do I create a stored procedure in mysql?

487


What is sql vs mysql?

516


Where’s database data actually stored?

514


Why phpmyadmin is used for mysql?

494


What is a tinyint in mysql?

478


How many rows can be inserted in mysql at a time?

487


What is the maximum number of records in mysql table?

448


Is mysql free download?

470


What is sqlyog?

607


Can mysql function return a table?

597