How do I optimize my site? Its gone slow

[farhanisfarhan]

Hello guys,

Just wanted someone to help me identify the problem in slow vBulletin forum.

I am on a cloud server with 8GB ram and Quadcore processors. CENTOS with PLESK.

URL is: http://bit.ly/bRkAmE

I know there are some issues related to mySQL which need to be addressed. I have tried all the possibilities before I am posting my issue here. even my SSH is so slow and my PLESK won't let me do anything as it says mysql errors.


My my.cnf file looks like (after running mysqltuner):

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-bdb
set-variable=max_connections=800
set-variable=key_buffer=128M
set-variable=myisam_sort_buffer_size=64M
set-variable=join_buffer_size=1M
set-variable=read_buffer_size=2M
set-variable=sort_buffer_size=2M
set-variable=table_cache=2000
set-variable=thread_cache_size=128
set-variable=wait_timeout=600
set-variable=interactive_timeout=600
set-variable=connect_timeout=10
set-variable=tmp_table_size=64M
set-variable=max_heap_table_size=64M
set-variable=max_allowed_packet=64M
set-variable=max_connect_errors=10
set-variable=thread_concurrency=4
set-variable=read_rnd_buffer_size=524288
set-variable=bulk_insert_buffer_size=8M
set-variable=query_cache_limit=4M
set-variable=query_cache_size=64M
set-variable=query_cache_type=1
set-variable=query_prealloc_size=131072
set-variable=query_alloc_block_size=65536
set-variable=default-storage-engine=MyISAM

[mysql.server]
user=mysql
basedir=/var/lib


[mysqld_safe]
nice = -5
open_files_limit=8192
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet=16M

[myisamchk]
set-variable=key_buffer=64M
set-variable=sort_buffer=64M
set-variable=read_buffer=16M
set-variable=write_buffer=16M