Skip to main content

igh CPU from MYSQL more than 100%

redorblack99
Hello everyone i need urgent help i have my AWS EC2 8 core 36 Ram T2xxl working fine up to 1 year today i found the CPU over 100% frist i try top -cd3 then i tried

Comments

8 comments

Date Votes
  • redorblack99
    Hello everyone i need urgent help i have my AWS EC2 8 core 36 Ram T2xxl working fine up to 1 year today i found the CPU over 100% frist i try top -cd3 then i tried from searching here mysqladmin proc status anyone can help me please what is Causing the problem
    0
  • cPRex Jurassic Moderator
    Hey there! It definitely looks like an issue with the migochat account, as that database is the one that is generating a log of sleep queries. You'll likely want to work with a professional MySQL administrator to determine why that database is suddenly experiencing issues, as everything else on the system seems normal.
    0
  • redorblack99
    I
    Hey there! It definitely looks like an issue with the migochat account, as that database is the one that is generating a log of sleep queries. You'll likely want to work with a professional MySQL administrator to determine why that database is suddenly experiencing issues, as everything else on the system seems normal.

    Thanks for your reply today everything back to normal server load is not 2 or 3 of 8 server has only one account Migochat also there way cronjob for the system installed script recommend it to set every 5 minute and i set it for 1 minute by mistake and when i edit it yesterday issue is gone , what do you think i keep it that way or search for professional MySQL administrator to help me ? im not sure what i did fixed the issue
    0
  • cPRex Jurassic Moderator
    What was the cron job that you changed?
    0
  • redorblack99
    What was the cron job that you changed?

    it's from the script i installed, any way problem is back today same also Cpanel support said that problem because of stealing % of cpu is 30% i did not understand what is Stealing or how to fix it or if stealing 30% is all the problem or part of it
    0
  • vanessa
    You probably want to have a developer look into this for you. From first glance, your app appears to be using persistent connections, which is typically unneeded when using a local SQL server. Consider also running the tuner to see if you can adjust anything -
    0
  • redorblack99
    You probably want to have a developer look into this for you. From first glance, your app appears to be using persistent connections, which is typically unneeded when using a local SQL server. Consider also running the tuner to see if you can adjust anything -
    0
  • vanessa
    This isn't a cPanel issue, so these forums are likely not the best place to ask for help with optimizing your application's MySQL database. My only suggestion is if you're using Cloudlinux, if MySQL Governor is running it could explain the high usage and cause queries to get stuck.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post