Re: Innodb file sizes

2001-11-02 Thread Stephen Lee
> 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-rw1 mysqlmysql2560 Nov 2 12:1

Re: Innodb file sizes

2001-11-02 Thread Dan Nelson
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-rw1 mysqlmysql2560 Nov 2 12:17 ib_arc

Innodb file sizes

2001-11-02 Thread Stephen Lee
I have the following settings in /etc/my.cnf: default-table-type=innodb innodb_data_file_path = ibdata1:1000M innodb_data_home_dir = /var/lib/mysql/ innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_