Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB Overload :((

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by YuchiRO, Jan 12, 2015.

  1. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    4:40 PM
    5.5.4
    Here is my top-c Screenshot by Lightshot

    Normally load aveage: 0.7 - 1 or 2 is max, but today is 10 or more.
    Cpu over 60% us

    Today i didnt change anything ... but some thing wong with vps :(

    Btw, what is TIME+ meaning ? I always see mysqld use alot and over 200:0:

    Regards
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    7:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    Depending on MySQL usage activity that can be normal as MySQL/MariaDB is multi threaded in nature so uses as many cpu cores/threads as needed i.e. 200% = 2 cpu threads in use, 250% = 2.5 cpu threads in use - all normal. Unfortunately, Centmin Mod is provided as is, it's up to you yourself to optimise and tune your server settings for your specific loads.

    Some hints on where to look for config/setting files for respective software below:

    Official site FAQ item 16 & 19 has some info at Centmin Mod FAQ - Menu based Nginx installer as does PHP-FPM page at PHP PHP-FPM - Centmin Mod - Menu based Nginx installer for CentOS servers and Centmin Mod Insights forum i.e. PHP Opcode and Memcached statistics pages | Centmin Mod Community

    As to specific values, optimisation is left to end user as I provide Centmin Mod as is.. forum search has some hints i.e. PHP-FPM - pm.max_children | Centmin Mod Community

    For MySQL, look at my mysqlmymonlite.sh addon which allows you to gather all relevant stats quickly Add Ons | Centmin Mod Community What you do with those stats are up to you i.e. provide it to hired consultants or post on forums (not necessarily this forum) in CODE tags for respective advice. I do not provide optimisation advice for free though, but other members are free to offer advice if they want.

    Also cpu load of 12 is cummulative over all cpu threads. So if you have a 12 cpu thread server, cpu load of 12 is really only 12/12 = cpu load average of 1.0 or 100% which is normal. If only 6 cpu threads, then cpu load of 12 = 12/6 = cpu load average of 2.0 or 200% which is high but can still be within normal depending on age and architecture of the cpu model/brand used.

    And as to TOP stats meaning read top - Linux Command - Unix Command
     
    Last edited: Jan 12, 2015
  3. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    4:40 PM
    5.5.4
    @eva2000 Thanks for your help.

    I setup vps and running for a month without any problem, but something wrong today when i watch top.
    VPS load higher and hang-on.

    I agree to pay to fix this issue or find what happy on vps.

    How to contact you ?
     
  4. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    4:40 PM
    5.5.4
    AM569Qn.png
    I upload a picture on first post about my "top"

    I attach again ..
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    7:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    My optimisation consult rates start in the 4 figure $$$$ range for minimum of 4 days work however I am pretty much booked up in advance with paid up clients until end of February 2015 right now and still have dozens of enquiring clients each day. To contact me for such work or details and my schedule, you need to contact me via my blog at Contact | vbtechsupport.com
     
  6. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    4:40 PM
    5.5.4
    @eva2000 Thanks.
    But now, my site is going to die :(, i cant wait until 15 - Feb.

    Should you have any advice for me to bring up vps back now ?
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    7:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    well you need to figure out how mysql is utilisation so much cpu time and what for - my mysqlmymonlite.sh script mentioned in 2nd post should be able to quickly gather all relevant stats for brief summary - may need further analysis to get to bottom of it though. Sample output of all stats gathered by mysqlmymonlite.sh is displayed at mysqlmymonlite.sh & mysqlmymon.sh server and mysql stats gathering tool

    Also might want to ask @Matt who is a Centmin Mod Community moderator and also has his own paid services Moderator appointments = Matt | Centmin Mod Community
     
  8. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    4:40 PM
    5.5.4
    @eva2000 Thanks.

    I install mysqlmymonlite and .. i didnt find any trouble in mysql.

    Which report is needed to find problem ?
    Btw, would you take a flash view on my vps please ?

    Regards.
     
  9. eva2000

    eva2000 Administrator Staff Member

    30,196
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    7:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    You'll have to figure it out on your own - unfortunately, I already have dozens of paying consult clients I need to prioritise first.

    For mysqlmymonlite - if you check out web site's example displayed stats at mysqlmymon.com, next to each example there's a column linking to info and documentation regarding each of the example displayed stats for you to understand what you're seeing.
     
  10. Steve Tozer

    Steve Tozer Member

    70
    42
    18
    Jul 28, 2014
    South Wales, UK
    Ratings:
    +49
    Local Time:
    10:40 AM
    1.91
    10.0.19
    Looking at your top screen shot, Seems to be a lot of nginx process running, have you checked to see if there isn't a bot or small DDoS attack hitting your site? This could be causing high DB load.

    Check

    Code:
    /home/nginx/domains/yourdomainname/log/access.log
    See if there is a particular IP address hitting your site constantly.
     
    • Like Like x 1