mysql -uroot -p… -e”SET GLOBAL innodb_fast_shutdown = 0″
service mysql stop
rm -f /var/lib/mysql/ib_logfile[01]
service mysql start
Step 3 will recreate ib_logfile0 and ib_logfile1
safely change InnoDB pool_size
Leave a reply
mysql -uroot -p… -e”SET GLOBAL innodb_fast_shutdown = 0″
service mysql stop
rm -f /var/lib/mysql/ib_logfile[01]
service mysql start
Step 3 will recreate ib_logfile0 and ib_logfile1