本文共 526 字，大约阅读时间需要 1 分钟。

Don't forget to resize the InnoDB Log Files (ib_logfile0 and ib_logfile1). MySQL Source Code places a cap of the combined sizes of all InnoDB Log Files must be < 4G (4096M).For the sake of simplicity, given just two log files, here is how you can size them:

• Step 1) Add innodb_log_file_size=NNN to /etc/my.cnf(NNN should be 25% of innodb_buffer_pool_size or 2047M, whichever is smaller)
• Step 2) service mysql stop
• Step 3) rm /var/log/mysql/ib_logfile[01]
• Step 4) service mysql start (ib_logfile0 and ib_logfile1 are recreated)

转载地址：https://blog.csdn.net/caiyiii/article/details/11472497 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！