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: 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