MySQL 5.5 Release Notes
[+/-]
- 14.9.1 InnoDB Startup Configuration
- 14.9.2 InnoDB Buffer Pool Configuration
- 14.9.3 Configuring the Memory Allocator for InnoDB
- 14.9.4 Configuring InnoDB Change Buffering
- 14.9.5 Configuring Thread Concurrency for InnoDB
- 14.9.6 Configuring the Number of Background InnoDB I/O Threads
- 14.9.7 Configuring the InnoDB Master Thread I/O Rate
- 14.9.8 Configuring Spin Lock Polling
- 14.9.9 Configuring InnoDB Purge Scheduling
- 14.9.10 Configuring Optimizer Statistics for InnoDB
This section provides configuration information and procedures for
InnoDB initialization, startup, and various
components and features of the InnoDB storage
engine. For information about optimizing database operations for
InnoDB tables, see
Section 8.5, “Optimizing for InnoDB Tables”.
[extract from /etc/mysql/my.cnf]
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
If you start getting "Table 'foo' is full" errors, check your config file.
innodb_data_file_path=/History/mysql/ibdata1:10M:autoextend:max:15G
Upon starting mysql, I got an error unable to open database. When I looked in syslog, the innodb_data_file_path looked like this
.//History/mysql/ibdata
I added to the my.cnf
innodb_data_home_dir=/History/mysql
and modified innodb_data_file_path to
innodb_data_file_path=ibdata:10M:autoextend:max:15G
and mysql started up using the correct file paths. Remember to change the permissions on the /History/mysql directory to chown mysql:mysql mysql. All is well and I was also able to change the log file locations as well.
# Set key_buffer to 5 - 50% of your RAM depending on how much
# you use MyISAM tables, but keep key_buffer_size + InnoDB
# buffer pool size < 80% of your RAM
It is not really clear but 'key_buffer_size' is a MyISAM parameter so the sentence above means that the more you use MyISAM table the higher key_buffer_size should be.
It wasn't really clear to me at the beginning.