Here are my suggested settings for the my.cnf file. This should work well for a VPS with 256-512MB RAM. Code: [mysqld] max_connections = 400 key_buffer = 16M myisam_sort_buffer_size = 32M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1024 thread_cache_size = 286 interactive_timeout = 25 wait_timeout = 1000 connect_timeout = 10 max_allowed_packet [...]
If you enjoy our post, feel free to subscribes to our rss feeds














