Take the 2-minute tour ×  I am using Centos 6 64bit on vps with
4gb ram. 1 wordpress website and 2 wallpapers script websites.
Wordrpess have 10k visits daily. Site is slow.   # Example mysql
config file for large systems. # This is for large system with
memory = 512M where the system runs mainly # MySQL. # You can
copy this file to # /etc/my.cnf to set global options, #
installation this directory is /usr/local/mysql/var) or #
~/.my.cnf to set user-specific options. # One can in this file
use all long options that the program supports. # If you want to
know which options a program support, run the program # with
--help option.  # The following options will be passed to all
MySQL clients #password   = your_password port        = 3306
socket      = /tmp/mysql.sock  # Here follows entries for some
specific programs  # The MySQL server port        = 3306 socket
= /tmp/mysql.sock set-variable    = key_buffer=256M set-variable
= max_allowed_packet=1M set-variable    = table_cache=256 set-
variable    = sort