【已完成】mysql重启失败

==========================================================================================
Data locked: NO

Event queue status:
Element count   : 0
Data locked     : NO
Attempting lock : NO
LLA             : init_queue:139
LUA             : init_queue:149
WOC             : NO
Next activation : never
2020-12-31 09:43:04 27280 [ERROR] InnoDB: The total blob data length (1244963) is greater than 10% of the total redo log size (10485760). Please increase total redo log size.
2020-12-31 09:43:04 27280 [ERROR] InnoDB: The total blob data length (1244963) is greater than 10% of the total redo log size (10485760). Please increase total redo log size.
2020-12-31 09:44:17 27280 [ERROR] InnoDB: The total blob data length (1241035) is greater than 10% of the total redo log size (10485760). Please increase total redo log size.
2020-12-31 09:44:18 27280 [ERROR] InnoDB: The total blob data length (1241035) is greater than 10% of the total redo log size (10485760). Please increase total redo log size.
2021-10-02 02:32:36 27280 [Warning] Disk is full writing './mysql-bin.000012' (Errcode: 28 - No space left on device). Waiting for someone to free space...
2021-10-02 02:32:36 27280 [Warning] Retry in 60 secs. Message reprinted in 600 secs
2021-10-26 11:40:52 27280 [Note] /www/server/mysql/bin/mysqld: Normal shutdown

2021-10-26 11:40:52 27280 [Note] Giving 0 client threads a chance to die gracefully
2021-10-26 11:40:52 27280 [Note] Event Scheduler: Purging the queue. 0 events
2021-10-26 11:40:52 27280 [Note] Shutting down slave threads
2021-10-26 11:40:52 27280 [Note] Forcefully disconnecting 0 remaining clients
2021-10-26 11:40:52 27280 [Note] Binlog end
2021-10-26 11:40:52 27280 [Note] Shutting down plugin 'partition'

您好，去命令行修改 vi /etc/my.conf里的
innodb_log_file_size = 30M
innodb_log_buffer_size = 512M
将值调大点，再重启MySQL试试

加上了，错误依旧
innodb_log_file_size = 128M
innodb_log_buffer_size = 512M

您可以检查一下磁盘使用

1. df -h

复制代码

Filesystem             Size  Used Avail Use% Mounted on
/dev/vda1               50G   35G   13G  74% /
/dev/mapper/vg00-lv00   50G  180M   47G   1% /newdata

wget -O /etc/my.cnf http://download.bt.cn/install/conf/mysql-5.6.conf -T 5
覆盖mysql配置后成功，留给后来的xdm

感谢您的分享

/etc/init.d/mysqld stop
rm -f /www/server/data/ib_logfile*
rm -f /www/server/data/mysql-bin.*
/etc/init.d/mysqld start