mysql 硬盘死机_磁盘空间不够导致mysql崩溃重启

起因：

群里有人提了句pt-ioprofile，我不知道，就查了查，想测一测，想以后可能会有帮助。

为了能看到效果，我选择了我虚拟机上最大的压测表Sbtest1，该表有100w数据，执行update sbtest1 set k=k+1;

并且通过pt-ioprofile查看到了想要的结果，然后就干别的去了，下午了，看update sbtest1 set k=k+1;这个窗口的光标还闪着，以为还没执行完，不停地回车，crtl c，各种不好用。过了一会儿，报错了，并且提示mysql已经重启了。

我去他嘞

报错信息为：Binary logging not possible. Message: An error occurred during flush stage of the commit.'binlog_error_action' is set to 'ABORT_SERVER'. Hence aborting the server.

给出这个，我也看不明白

查看错误日志：

2018-11-01T11:25:54.493321+08:00 895 [Note] Access denied for user 'root'@'localhost' (using password: NO)

2018-11-01T11:29:17.566331+08:00 896 [ERROR] Disk is full writing '/data/mysql/mysql-bin.000025' (Errcode: 16026912 - No space left on device). Waiting for someone to free space...

2018-11-01T11:29:17.566355+08:00 896 [ERROR] Retry in 60 secs. Message reprinted in 600 secs

2018-11-01T11:30:17.567664+08:00 896 [ERROR] Disk is full writing '/data/mysql/mysql-bin.000025' (Errcode: 16026912 - No space left on device). Waiting for someone to free space...

2018-11-01T11:30:17.567705+08:00 896 [ERROR] Retry in 60 secs. Message reprinted in 600 secs

2018-11-01T11:40:17.641906+08:00 896 [ERROR] Disk is full writing '/data/mysql/mysql-bin.000025' (Errcode: 16026912 - No space left o