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