Suppose your are adding rows to a MyISAM table and the server runs out of disk space. What will happen?

The correct answer is C. The server suspends that INSERT operation until space becomes available. If you run out of disk space while adding rows to a MyISAM table, no error occurs. The server suspends the operation until space becomes available, and then completes the

MySQL Storage Engines

Question

Options

AThe server will crash.
BAn error message will be returned to the client.
CThe server suspends that INSERT operation until space becomes available.
DThe server suspends operations on all MyISAM tables until space becomes available.

How the community answered

(31 responses)

A
3% (1)
B
6% (2)
C
77% (24)
D
13% (4)

Explanation

If you run out of disk space while adding rows to a MyISAM table, no error occurs. The server suspends the operation until space becomes available, and then completes the

Topics

#MyISAM#disk space handling#INSERT behavior#server error handling

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice