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

March 27, 2015 7.6k views
Load Balancing MySQL Server Optimization Apache
bekircem
By:
bekircem

Hi.

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?

1 comment
Log In to Comment
3 Answers
Viko March 27, 2015

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: http://pastebin.com/

Reply
  • bekircem March 27, 2015

    Do you want access_log or error_log files? In /var/log/httpd directory, there is too much access_log file and each** access_log** file size** greater than 700MB**.

  • Viko March 27, 2015

    Yeah, this are the correct files!

    There is no need to have the full file, just copy the last 100 or so lines and paste them in pastebin. Then you can post the link and I will try to check this for you.

  • bekircem March 27, 2015

    Here is the last error_log files updates. Why access_log files size is greater than 700MB? Is this a problem?

  • bekircem March 27, 2015

    Sorry. I send wrong error_log. Last error_log file for 2 day.

  • Viko March 27, 2015

    Thanks!

    This surely provides some information. Can You also post the access log. There is no need of the full file, only the most recent 100-150 lines.

  • bekircem March 27, 2015

    Last access_log file is 800 MB. :( If i download that file this is take a time?

  • Viko March 27, 2015

    You can open the file through console:

    vi /var/logs/httpd/desiredaccesslog_name

  • bekircem March 27, 2015

    I reached access_log for 22 March. Here it is.

  • bekircem March 27, 2015

    Viko, are you there?

  • Viko March 27, 2015

    Indeed, I am here! :)

    Thanks for the logs. This requires some step-by-step troubleshooting.

    What first came to my attention is that PageSpeed is causing a lot of trouble. Almost all errors are related to it. As I have never needed, nor used PageSpeed, my suggestion is to first temporarily disable it and restart Apache. This will clearly show if it causes the problems.

    New question came in my mind: Are you using a firewall of any kind?

  • bekircem March 27, 2015

    Hi Viko,

    We can't fix Page Speed? I want to use Page Speed. But i can't understand. Why PageSpeed is causing trouble?

    I don't use firewall. Just i use CloudFlare.

    Edit: I disabled Page Speed module. What is the next? Thank you so much for your help! :)

  • Viko March 27, 2015

    Hi!

    As I mentioned - I do not have a lot of experience with the pagespeed module, so I can not guide you how to set it up correctly. After disabling it and restarting the Apache web server, how does the Droplet act?
    What are the new messages in the error log?

  • bekircem March 27, 2015

    Hi.

    Here it is last 100 line in error_log. It seems this error for APC. http://178.62.236.239/apc.php

    And i have question for you. In /var/log/httpd directory access_log files is greater than 700MB. It is normal?

    What is the next?

    Thank you again.

  • bekircem March 27, 2015

    Hi Viko,

    I fix lastest date.timezone problem. I am edited php.ini.

    [Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = "Europe/Istanbul"

    What is the next step?

  • bekircem March 27, 2015

    Hi Viko,

    My problem has continues.

    I am still waiting for solution and your suggestions.

    Thank you. :)

Viko March 27, 2015
[deleted]
Reply
Viko March 27, 2015
[deleted]
Reply
Have another answer? Share your knowledge.

Related Questions