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

Are you sure this is a database problem? How high is the load on your server with intensive DB operations (use "top" to find out)? Try to identify the slow queries (using the slow query log) and optimize them. Do you have all the indexes you might use?