Join the community today
Become a Member

MariaDB How to check and resolve errors on mysql

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by quach, Apr 10, 2015.

  1. quach

    quach New Member

    10
    0
    1
    Apr 9, 2015
    Ratings:
    +0
    Local Time:
    9:05 AM
    eva2000.07
    Hi al,

    My VPS always get overload on CPU. I checked on SSH and i think mysql have problem. That's the reason why the CPU overload with over 100%.

    I checked my database on hosting and optimize it on myPHPadmin before move it to VPS . No error detect on my database. But this CPU on VPS always alert over 100% , and my site overload after that.

    my screenshot CPU overload : Gyazo - 20cb29f5b0f16f80545b4277e266aa0c.png

    How can i resolve this problem ? Anyone can help me .

    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,132
    6,778
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,128
    Local Time:
    12:05 PM
    Nginx 1.13.x
    MariaDB 5.5
    Centmin Mod is provided as is with an optimal base configuration. However, tuning settings for your specific site loads is left to end user to do or you can ask on this forum and other members here might help but I stay out of optimisation/tweaking advice as I do not do that for free on the forums.

    You can use my Centmin Mod Addon for mysqlmymonlite.sh to further gather server and mysql stats and config info. Takes 12 seconds or so to gather all info you see at mysqlmymon.com. You can use that outputted info to post on forums in CODE tags or provide to hired help so they can instantly get a complete overview of your server hardware configuration, config settings and usage loads at a glance.
     
    • Like Like x 1