why can't innodb_log_file_size change
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
Re: why can't innodb_log_file_size change
You should be able to do this by: 1) Stopping the server cleanly 2) Removing the log files 3) Restarting the server with the new log file sizes set in your .cnf Chris Dathan Vance Pattishall wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]