I've tried it 4 months ago, and at that time it seemed to reduce the load tremendously.
This was intended for use with Linux VPS/Dedicated servers, with DirectAdmin installed
Some options or path may not be correct for other servers.
----
The MySQL config file should be located here:
/etc/my.cnf
Basically, replace the content of your my.cnf file and edit to your server's hardware config. I usually rename the original file, make a new file with my edits. Up to you.
Note:
I'm not expert in optimizing servers, so please give some feedback on it's effect on your server.
Post up if you think something should be changed.
This was intended for use with Linux VPS/Dedicated servers, with DirectAdmin installed
Some options or path may not be correct for other servers.
----
The MySQL config file should be located here:
/etc/my.cnf
Basically, replace the content of your my.cnf file and edit to your server's hardware config. I usually rename the original file, make a new file with my edits. Up to you.
Note:
I'm not expert in optimizing servers, so please give some feedback on it's effect on your server.
Post up if you think something should be changed.
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=64M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=128M ## 64MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M ## 1MB for every 1GB of RAM
read_buffer_size=2M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci
old-passwords
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout