CentOSThere 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.
Debian/FreeBSDWe 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.6New 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 - DO NOT USE
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|
© 2018 JBMC Software, Suite 173 3-11 Bellerose Drive, St Albert, AB T8N 1P7 Canada. Mon-Fri 9AM-5PM MST