There is a default my.cnf that comes with mysql (4+5) that will make mysql run a bit quicker if you have 2+ gig of ram
cp -f /usr/share/mysql/my-large.cnf /etc/my.cnfThere is also my-huge.cnf, or my-medium.cnf depending on your hardware setup. Check the contents of these my*.cnf files for the one that's right for you.
*NOTE 1* the log-bin option is enabled by default. This will quickly use a lot of disk space. It's recommended to comment out the log-bin line from your /etc/my.cnf, if it exists.
*NOTE 2* Take note of your old /etc/my.cnf file. If you have innodb_file_per_table=1 make sure the new my.cnf you install also has this setting. Similarly, if your old one does not have innodb_file_per_table=1 enabled, then your new my.cnf should also not have it enabled. If the new my.cnf has a different setting for innodb_file_per_table, then it may corrupt your data.
Be sure to make full backups of your .sql files before doing any changes to your my.cnf.
We don't currently have optimized my.cnf files for these OSs.
The /etc/my.cnf will rely on the internal defaults in the mysqld binaries.
CentOS and MySQL 5.6
New MySQL installs might not have any included my-*.cnf files.
We've added a few from MySQL 5.5 which seem to work with 5.6, eg:
cp /etc/my.cnf /etc/my.cnf.old
MySQL 4.x - Depreciated
If you've got mysql 4 (and not mysql 5), then you can use the following code in your /etc/my.cnf:
Referenced from the Forum
vi /etc/my.cnf [ENTER]Press 'i' to enter insert mode, then paste:
/sbin/service mysqld restart
|How to track MySQL Load|
|I have many mysql-bin files which are using up a lot of space|
© 2003 JBMC Software, Suite 173 3-11 Bellerose Drive, St Albert, AB T8N 1P7 Canada. Mon-Fri 9AM-5PM MST