宝塔用户_zcrggy 发表于 2022-11-24 16:42:22

【已完成】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 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 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 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 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 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 Retry in 60 secs. Message reprinted in 600 secs
2021-10-26 11:40:52 27280 /www/server/mysql/bin/mysqld: Normal shutdown

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

盏尽 发表于 2022-11-24 16:48:57

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

宝塔用户_zcrggy 发表于 2022-11-24 16:56:40

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

盏尽 发表于 2022-11-24 16:58:24

您可以检查一下磁盘使用
df -h

宝塔用户_zcrggy 发表于 2022-11-24 17:01:15

Filesystem             SizeUsed Avail Use% Mounted on
/dev/vda1               50G   35G   13G74% /
/dev/mapper/vg00-lv00   50G180M   47G   1% /newdata

宝塔用户_zcrggy 发表于 2022-11-24 17:33:45

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

南南呦 发表于 2022-11-24 17:40:00

感谢您的分享

张生1988 发表于 2024-4-3 22:55:25

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

页: [1]
查看完整版本: 【已完成】mysql重启失败