MySQL Architecture — Concept Check
Questions on MySQL Architecture. MySQL's architecture layers: connection handling (thread pool), parser/optimiser, storage engine API, and pluggable engines (InnoDB, MyISAM) — understanding each layer aids query tuning.
Questions in this quiz
8 questions on MySQL Architecture — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A MySQL database is experiencing slow query performance. The EXPLAIN output shows a full table scan. Which layer should you investigate to address this issue?
- AClient application layer, focusing on SQL syntax
- BConnection layer, focusing on thread pool
- CStorage engine layer, focusing on InnoDB
- DServer layer, focusing on the query optimiser
2.After enabling SSL/TLS for MySQL connections, the server's CPU usage spikes. What could be the cause?
- AIncreased CPU load due to SSL/TLS encryption
- BHigh network latency due to SSL/TLS
- CIncreased disk I/O from InnoDB
- DExcessive memory usage by the buffer pool
3.A MySQL server shows a low buffer pool hit ratio. What is a likely consequence?
- AIncreased CPU usage due to query parsing
- BDecreased network throughput due to slower connections
- CReduced SSL/TLS performance
- DIncreased disk I/O as pages are read from disk more frequently
4.Which of the following is NOT a feature of the InnoDB storage engine?
- AMVCC for read consistency
- BACID compliance
- CFull-text search capabilities
- DRow-level locking
5.A developer notices that queries involving views are running slower than expected. What should be examined first?
- ASSL/TLS settings in the connection layer
- BBuffer pool size in InnoDB
- CThread pool in the connection layer
- DQuery rewriter in the server layer
6.Which of the following statements about MySQL's connection layer is FALSE?
- AIt terminates SSL/TLS connections
- BIt manages a thread pool for handling connections
- CIt optimises queries using indexes
- DIt handles authentication using caching_sha2_password
7.A MySQL server's redo log is set to a very small size. What is a likely impact?
- AFaster query parsing
- BFrequent log flushing, reducing write throughput
- CIncreased buffer pool hit ratio
- DImproved SSL/TLS performance
8.What is the primary purpose of the InnoDB buffer pool?
- ATo optimise query parsing
- BTo handle connection authentication
- CTo cache data and index pages in memory
- DTo manage SSL/TLS encryption