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 |
What is mysqli_free_result?
How can you handle the –secure-file-priv in mysql?
Does mysql automatically index foreign keys?
What are different types of queries?
How many threads can mysql handle?
What is dirty read and phantom read?
What language does mysql use?
What is mysql workbench used for?
Is there a free version of mysql?
State the differences between mongodb and mysql.
What's the difference between mysql and sql server?
What is difference between mysql and mysql workbench?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)