Which of the following statements are true for MyISAM tables?

Question

Options

• ABy default, write requests (such as UPDATE and DELETE statements) take priority over read
• BBy default, read requests (such as SELECT statements) take priority over write requests (such as
• CWith the LOW_PRIORITY option, a write request will wait for any other read request to finish.
• DWith the LOW_PRIORITY option, a read request will wait for any other write request to finish.
• EWith the HIGH_PRIORITY option, a read request will be moved ahead of other requests waiting

• A
  77% (23)
• B
  10% (3)
• D
  13% (4)

Explanation

By default, the server schedules queries for execution as follows: Write requests (such as UPDATE and DELETE statements) take priority over read requests (such as SELECT statements). The server tries to perform write requests in the order that it receives them. When working with MyISAM tables, certain scheduling modifiers are available to change the priority of requests: The LOW_PRIORITY modifier may be applied to statements that update tables (INSERT, DELETE, REPLACE, or UPDATE). A low-priority write request waits not only until all current readers have finished, but for any pending read requests that arrive while the write request itself HIGH_PRIORITY may be used with a SELECT statement to move it ahead of updates and ahead SELECT statements that do not use the HIGH_PRIORITY modifier.

No community discussion yet for this question.