Explain MySQL architecture.
Question :
Explain MySQL architecture.
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.)
Similar Questions
What is Django's middleware and how is it used?
- What are comments? Name the different types of comments used in Java.
- What are syntax errors? Give two examples.
- What are the different type of errors that may occur in a Java program?
- What is a bug? What is debugging?
- What is an accumulator?
- What is an expression?
- What is an operator? How is the classification of operators based upon?
- What is Type Conversion? Name the two type conversions in Java.
- What are separators?
- How are Decimal, Octal and Hexadecimal integer literals represented in Java?
- State two conventions you should follow while naming a class.
- What two conventions you should follow naming a class?
- State two rules you should follow for naming a class
- Why is a class called an object factory?
- What is an access specifier? Which two access specifier is used in a class declaration?
- Why is a class called a user defined data type?
- State two differences between a class and an object.
- State two differences between fundamental and user-defined data type.
- Explain the statement “Byte code is the object code for the JVMâ€