Help me to optimizing Mysql !!!
I have a vbulletin forum , my server is AMD 64 3800+ with 2GB RAM Cpanel,
My forum have 300 - 500 members online in same time :
please help me to optimizing mysql .
Here is my my.cnf,
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=500
safe-show-database
bind-address=127.0.0.1
log-slow-queries = /var/log/mysql_slow_query.log
connect_timeout=50
thread_cache_size=64
key_buffer_size=64M
join_buffer=1M
tmp_table_size=32M
max_allowed_packet=16M
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=500
safe-show-database
bind-address=127.0.0.1
log-slow-queries = /var/log/mysql_slow_query.log
connect_timeout=50
thread_cache_size=64
key_buffer_size=64M
join_buffer=1M
tmp_table_size=32M
max_allowed_packet=16M
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
