[rt-devel] Problem creating database with rt3rc4

[Michael K. Brown]

Hi Jesse!

Here's the Innodb config in my.cnf.  Could you point out any problems,
and maybe suggest a "typical" config for the list, since many folks may
be running MyISAM tables on RT2, and this may come up in the upgrade
process for others.

MySQL 3.23.49 - doesn't support :autoextend in innodb_data_file_path.
That starts in 3.23.50
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:10M
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_log_files_in_group=3
set-variable = innodb_log_file_size=64M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

Thanks for your time!
/Mike



-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Friday, March 21, 2003 10:20 AM
To: Michael K. Brown
Cc: 'Rt-Devel'
Subject: Re: [rt-devel] Problem creating database with rt3rc4

Sounds like you have innodb configured improperly.

pallas:% /usr/local/mysql/bin/perror 135                    ~
10:19AM:ttypts/10
Error code 135:  Unknown error 135
135 = No more room in record file