Hi all, First of all I am new with server using. Below my virtual private server details: Processor : 2.8 GHz Dual Core Processor Cores: 2 RAM Memory : 4GB Apache Version: Apache/2.2.3 (CentOS) PHP Version 5.1.6 MySQL Version: 5.0.77 HDD: 100GB Bandwidth: Unlimited Due to 3GB of database size, server may not respond some times and working very slow even if good server configuration. Website is running good on our local computers. I think, I need to change the mysql configuration settings for online server. Please help me out to set the best configuration of my.cnf for above server specially following settings: (Table type is MyISAM) connect_timeout = 20 key_buffer_size = 64M max_allowed_packet = 2G table_cache = 100M wait_timeout= 360 interactive_timeout = 360 key_buffer = 16M sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M Thanks in advance