Skip to content

Roger Hosto

Good Talk

Menu
  • Home
  • Blogs
    • Databases Administration
      • MySQL
      • NoSQL
    • Development
    • Open Source Software
    • System Administration
  • Resume
  • About
Menu

Resizing InnoDB Logs

Posted on August 26, 2016September 20, 2025 by webgeek

If you have already created your database and you change the setting for “innodb_log_file_size=###M” and restart here you database and get an error that looks something like

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes

Here what you need to do.
1.) Make sure your database shutdown clean.
2.) Move(not delete) any existing ib_logfile[#] to a safe place.
3.) edit the “innodb_log_file_size=###M” setting in your my.cnf.
4.) Restart your database and check your log file to make sure there were no errors.
5.) Check to make sure the new ib_logfile[#] are the right size.

Category: Databases Administration, MySQL
  • Back to Basics: ORM and Its Impact on Database and Data Architecture
  • MySQL Error: 1062 'Duplicate entry' Error
  • Installing MariaDB 10.1 on CentOS 6.8
  • Linux Mint
  • Querying Apache Hadoop Resource Manager with Python.
  • LinkedIn
© 2026 Roger Hosto | Powered by Minimalist Blog WordPress Theme