Trying to increase my innodb_log_file_size I get this message
031027 16:01:02 InnoDB: Data file ./ibdata2 did not exist: new to be
031027 16:01:02 InnoDB: Setting file ./ibdata2 size to 2000 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100
1200 1300 1400 1500 1600 1700 1800 1900 2000
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880
InnoDB: than specified in the .cnf file 0 78643200 bytes!
031027 16:01:57 Can't init databases
031027 16:01:57 Aborting
031027 16:01:57 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
031027 16:01:57 /usr/local/mysql/bin/mysqld: Shutdown Complete
The mysql doc says this:
Size of each log file in a log group in megabytes. Sensible values range
from 1M to 1/nth of the size of the buffer pool specified below, where n
is the number of log files in the group. The bigger the value, the less
checkpoint flush activity is needed in the buffer pool, saving disk I/O.
But bigger log files also mean that recovery will be slower in case of a
crash. The combined size of log files must be < 4 GB on 32-bit
computers. The default is 5M.
It doesn't say anything about not being able to increase the size of the
log file after its been set.
Any work a rounds?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.