更改innodb_log_file_size, 解决InnoDB: ERROR: the ag...的问题_MySQL
Jun 01, 2016 pm 01:42 PM
bitsCN.com
更改innodb_log_file_size, 解决InnoDB: ERROR: the ag...的问题 有时侯Mysql会报错: 120418 8:00:14 InnoDB: ERROR: the age of the last checkpoint is 9434204,InnoDB: which exceeds the log group capacity 9433498.InnoDB: If you are using big BLOB or TEXT rows, you must set theInnoDB: combined size of log files at least 10 times bigger than theInnoDB: largest such row 这主要是由于 innodb_log_file_size 默认是5M, 不够用引起的. 增大innodb_log_file_size的方法: 暂停mysql, /etc/init.d/mysql stop转移ib_logfile0和ib_logfile1, mv /usr/local/mysql/var/ib_logfile* ../编辑my.cnf , 增加 innodb_log_file_size=64M启动mysql, /etc/init.d/mysql start 作者 neou bitsCN.com
Hot Article
Hot tools Tags
Hot Article
Hot Article Tags
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Solution to PHP Fatal error: Call to undefined method PDO::prepare() in
Jun 22, 2023 pm 06:40 PM
Solution to PHP Fatal error: Call to undefined method PDO::prepare() in
Solve the problem of 'error: incomplete type is not allowed' in C++ code
Aug 26, 2023 pm 08:54 PM
Solve the problem of 'error: incomplete type is not allowed' in C++ code
What should I do if 'Uncaught (in promise) Error: Request failed with status code 500' occurs when using axios in a Vue application?
Jun 24, 2023 pm 05:33 PM
What should I do if 'Uncaught (in promise) Error: Request failed with status code 500' occurs when using axios in a Vue application?
0271: What should I do if the computer cannot be turned on due to real time clock error?
Mar 13, 2023 am 11:30 AM
0271: What should I do if the computer cannot be turned on due to real time clock error?
Solve the 'error: expected initializer before 'datatype'' problem in C++ code
Aug 25, 2023 pm 01:24 PM
Solve the 'error: expected initializer before 'datatype'' problem in C++ code
How to solve PHP Warning: fopen(): failed to open stream: No such file or directory
Aug 19, 2023 am 10:44 AM
How to solve PHP Warning: fopen(): failed to open stream: No such file or directory
Solution to PHP Fatal error: Call to undefined function mysqli_connect()
Jun 23, 2023 am 09:40 AM
Solution to PHP Fatal error: Call to undefined function mysqli_connect()
Solution to PHP Fatal error: Call to a member function fetch()
Jun 23, 2023 am 09:36 AM
Solution to PHP Fatal error: Call to a member function fetch()
