In the last episode (Nov 02), Stephen Lee said: > I have the following settings in /etc/my.cnf: > > default-table-type=innodb > innodb_data_file_path = ibdata1:1000M > set-variable = innodb_log_file_size=5M > > The resulting files: > -rw-rw---- 1 mysql mysql 2560 Nov 2 12:17 ib_arch_log_0000000000 > -rw-rw---- 1 mysql mysql 2560 Nov 2 12:20 ib_arch_log_0000000002 > -rw-rw---- 1 mysql mysql 2560 Nov 2 14:16 ib_arch_log_0000000004 > -rw-rw---- 1 mysql mysql 1048576000 Nov 2 14:16 ibdata1 > -rw-rw---- 1 mysql mysql 5242880 Nov 2 14:16 ib_logfile0 > -rw-rw---- 1 mysql mysql 5242880 Nov 2 09:30 ib_logfile1 > -rw-rw---- 1 mysql mysql 5242880 Nov 1 10:10 ib_logfile2
Which are exactly the sizes you specified in the config file. It's doing exactly what you asked. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php