What is ideal my.cnf and httpd.conf settings for Digital Ocean's 10$ droplet?

Posted March 27, 2015 10.4k views
MySQLApacheServer OptimizationLoad Balancing


I am using Digital Ocean’s 10$ droplet with Centos 6.5 64 bit + APC + Apache + Google Page Speed Module. My cpu load is high. Here is htop output.

My [mysqld] settings in my.cnf file:

max_connections = 500    
thread_cache_size = 128
key_buffer = 64M  
query_cache_type = 1
query_cache_size = 32M
query_cache_limit = 4M
table_cache = 2000      
low_priority_updates = 1

What do you suggest for my.cnf or httpd.conf settings?

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
3 answers

It is rather hard to determine why Apache consumes so much resources by the provided details. Can you provide a copy of Apache logs? By default they are located in /var/log/httpd on CentOS (except if you have setted up a custom log location). Just copy as much as you can from the Access and Error logs. You can paste them here: