How to resize Innodb log files?

by ovais.tariq  | categories: Innodb, MySQL  | views: 9402

Just in case you don’t know resizing Innodb log file is not just simple as changing the value of innodb_log_file_size in the MySQL configuration file. But its even more simpler. Follow the following steps and you will be done with the resizing:

Step 1

Stop the MySQL server and make sure it shuts down without any errors. You can have a look at the error log to see if there are no errors.

Step 2

Once the server has stopped, edit the configuration file and change the value of innodb_log_file_size to your desired value.

Step 3

Move the log file sizes ib_log* to some place out of the the directory where the log files reside.

Step 4

Now restart the server.

And you have successfully changed the log file size. Its not that difficult is it?

←

→

  • http://topsy.com/www.ovaistariq.net/474/how-to-resize-innodb-log-files/?utm_source=pingback&utm_campaign=L2 Tweets that mention How to resize Innodb log files? | ovais.tariq — Topsy.com

    [...] This post was mentioned on Twitter by ガレージ・キッド, Ovais Tariq. Ovais Tariq said: How to resize Innodb log files? | ovais.tariq http://t.co/yhkflr4 via @ovaistariq #mysql #innodb [...]

  • http://www.myfastrunningpc.com/pc/partition-assistant-assist-you-increase-the-size-of-system-partition/ Partition Assistant Assist you Increase the size of System Partition | My Fast Running PC

    [...] How to resize Innodb log files? | ovais.tariq [...]

blog comments powered by Disqus

This work is licensed under a Creative Commons Attribution 3.0 Unported License.