Suppose you are adding rows to a MyISAM table and the —datadir location runs out of disk space. What will happen when this occurs?
A. The server will crash.
B. The server suspends that INSERT operation until space becinstallmes available.
C. An error message will be returned to the client .Server Error: ER_IO
D. The server suspends operations for all storage engines until space becomes available.
Answer: B
假设你正在向MyISAM表中插入新数据，此时datadir的空间满了，这时会发生什么？
A． server宕机
B． INSERT操作被server挂起，直到有可用空间为止
C． Client会收到error message，内容为ER_IO
D． 所有存储引擎上的操作都会被server挂起，直到有可用空间为止http://www.cndba.cn/hbhe0316/article/22780

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL