What is ideal my.cnf and httpd.conf settings for Digital Ocean's 10$ droplet?
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:
datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock 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?
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.