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

How to create table show example

0 Answers  


How do I rename a table in mysql?

0 Answers  


What is the difference between primary and unique key

5 Answers   CSC,


How do you flush privileges?

0 Answers  


Explain what is mysql?

0 Answers  


What command is used to delete the data from the table without deleting the table structure?

0 Answers  


If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 Answers   ABC,


Create table employee (eno int(2),ename varchar(10)) ?

0 Answers  


What is sqlyog?

0 Answers  


How do you convert to a different table type?

1 Answers  


How to see the database architecture in MySQL??

3 Answers  


What is a heap table?

0 Answers  


Categories