List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:October 28 2003 12:12am
Subject:why can't innodb_log_file_size change
View as plain text  
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
created
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
bytes
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:
 

innodb_log_file_size 
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.
  - http://friendfinder.com/go/p40688
 


Thread
why can't innodb_log_file_size changeDathan Vance Pattishall28 Oct
  • Re: why can't innodb_log_file_size changeChris Tucker28 Oct