Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?

Solution (By Examveda Team)

This question is about MySQL and specifically how it handles delayed inserts. Delayed inserts are used when you want to add new rows to a table, but you don't want to slow down the current operation. Instead, the inserts are queued and executed later.

The question asks which system variable controls the size of the queue for delayed inserts per table. Here's the breakdown of the options:

Option A: fast_queue_size - This variable is not related to delayed inserts. It's used in other contexts.
Option B: general_queue_size - This variable also is not related to delayed inserts. It handles general query queues.
Option C: slow_queue_size - Like the others, this variable is unrelated to delayed inserts. It manages queries considered "slow."
Option D: delayed_queue_size - This is the correct answer. The delayed_queue_size system variable determines how many delayed INSERT statements can be queued per table before they start being rejected.

So the answer is Option D: delayed_queue_size.