I am new one for rent a server. I choose a CentOS VDS width 2G memory. After apache+mysql+php install and setting, My server cost 750MB and 1297MB free (I use
free -m to see it)
And then I run one page of mine (2 mysql fulltext union search, 4 jquery ajax process, 4 social plungin, one whether online api, header footer use php include), then use SSH
free -m, I see the memory will increase into 835MB, one page cost 85MB memory...
So that my site will support less only few custom at same time, else the VDS provider will punish a over memory used ... I also read some article from google, some guy only rent a 256MB VPS, buy do a good job. So how to
Optimization in my situation?
key_buffer_size = 256M max_allowed_packet = 4M table_open_cache = 256 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 ft_min_word_len = 2
Or still need modify