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* 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.
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