The cloud database RDS for NySQL has made a lot of optimizations in the kernel. In the following description of the optimized content, which items are correct? (Multiple choice)

Question

Options

• AThread pool, introduces the function of thread pool in the enterprise version, supports more
• BThe storage engine can automatically convert InnoDB to MyISAN, which is transparent to users
• CSecurity controls such as system libraries: prevent users from deleting system libraries by
• DMulti-threaded replication: only 5.7 introduces transaction-level multi-threaded replication,

• A
  100% (39)

Explanation

All four options describe genuine kernel-level optimizations made in cloud RDS for MySQL, so this question has no incorrect distractors - every choice is valid. Option A is correct because RDS for MySQL backports the thread pool feature from the MySQL Enterprise Edition, allowing the server to reuse threads across connections and support significantly higher concurrency than the default one-thread-per-connection model. Option B is correct in that RDS can automatically convert storage engines (notably MyISAM to InnoDB) transparently, improving transaction support and crash recovery without requiring user action - note the question text appears to have the engine names reversed due to a typo, as converting to InnoDB, not away from it, is the meaningful optimization. Option C is correct because RDS adds security guardrails around system libraries and schemas, blocking accidental or unauthorized deletion that could corrupt the database environment. Option D is correct because MySQL 5.7 introduced logical-clock-based, transaction-level multi-threaded replication, a major step beyond the database-level parallelism available in 5.6, allowing replica servers to replay transactions in parallel with finer granularity.

Memory tip: Group the four optimizations by concern - Concurrency (thread pool), Storage (engine conversion), Safety (system library protection), and Sync (multi-threaded replication) - and you can reconstruct each answer from first principles rather than memorizing the list.

No community discussion yet for this question.