Changing innodb_log_file_size of MySQL-Server.
Steps to change innodb_log_file_size without effecting of existing innodb tables's data.
1. Check innodb_fast_shutdown value in server variables. It is global variable. Before changing innodb_log_file_size, You have to set innodb_fast_shutdown = 0 or OFF.
2. Stop MySQL server.
3. Delete innodb log files.
4. Start MySQL server.
Setting of innodb_fast_shutdown=0 takes little time, to purge all data.
Steps to change innodb_log_file_size without effecting of existing innodb tables's data.
1. Check innodb_fast_shutdown value in server variables. It is global variable. Before changing innodb_log_file_size, You have to set innodb_fast_shutdown = 0 or OFF.
2. Stop MySQL server.
3. Delete innodb log files.
4. Start MySQL server.
Setting of innodb_fast_shutdown=0 takes little time, to purge all data.
