mysql going crazy HELP

  • Hi I have a video tube website on wordpress. I am hosted on a very fast and powerful dedicated server. I noticed recently that my site is very slow and my admin area is also extremely slow. I contacted my host and they said mysql is going crazy. Mysql causing my server load to almost reach the point of crashing my server. Keep in mind this is serious because my server is so powerful it takes a lot to crash it.

    I notice this issue gets even worse when using the wp admin area. I have already tried optimizing and repairing the database tables via phpmyadmin.

    I have also tried disabling plugins and switching between different themes. None of these fixed the issue. Lastly I tried re-installing wordpress using the built in utility in “updates” section, that did not work either. My host has no idea and keeps blaming stuff on my end. I have no clue what to do now.

    here is the queries my host sent me:
    mysql 657 /usr/sbin/mysqld –basedir/usr –datadir/var/lib/mysql –plugin-dir/usr/lib64/mysql/plugin –usermysql –log-error/var/lib/mysql/dwhsv160.dwhs.net.err –open-files-limit10000 –pid-file/var/lib/mysql/dwhsv160.dwhs.net.pid
    mysql 656 /usr/sbin/mysqld –basedir/usr –datadir/var/lib/mysql –plugin-dir/usr/lib64/mysql/plugin –usermysql –log-error/var/lib/mysql/dwhsv160.dwhs.net.err –open-files-limit10000 –pid-file/var/lib/mysql/dwhsv160.dwhs.net.pid
    mysql 649 /usr/sbin/mysqld –basedir/usr –datadir/var/lib/mysql –plugin-dir/usr/lib64/mysql/plugin –usermysql –log-error/var/lib/mysql/dwhsv160.dwhs.net.err –open-files-limit10000 –pid-file/var/lib/mysql/dwhsv160.dwhs.net.pid
    [5/23/2015 5:05:49 PM] WebHost.pro: The 657 should not go over 10 normally. You are at 657
    [5/23/2015 5:05:54 PM] WebHost.pro: Wow.

    so he says it shouldn’t go over 10 but I am at 657.

    here is some data from WHM:

    User Domain % CPU % MEM MySQL Processes
    mysql 64.06 1.61 0.0
    sminix84 mastermentalism.org 2.56 2.27 20.1
    nobody 0.39 0.00 0.0
    root 0.17 0.70 2.0
    mailnull 0.04 0.00 0.0
    mailman 0.02 0.00 0.0
    named 0.00 0.10 0.0
    dovecot 0.00 0.00 0.0
    dovenull 0.00 0.00 0.0
    sshd 0.00 0.00 0.0
    unauthenticated 0.00 0.00 0.0
    leechprotect 0.00 0.00 0.9
    eximstats 0.00 0.00 1.0

    User Domain % CPU Process
    Top Processes
    root 9.5 lfd – (child) (PT) checking user processes
    sminix84 mastermentalism.org 9.2 [php] <defunct>
    sminix84 mastermentalism.org 9.1 [php] <defunct>
    mailnull 8.0 /usr/sbin/exim -Mc 1YwsDd-00046w-EJ
    mailnull 7.0 /usr/sbin/exim -Mc 1YwsIT-0004gv-5Y
    mysql 648 /usr/sbin/mysqld –basedir/usr –datadir/var/lib/mysql –plugin-dir/usr/lib64/mysql/plugin –usermysql –log-error/var/lib/mysql/dwhsv160.dwhs.net.err –open-files-limit10000 –pid-file/var/lib/mysql/dwhsv160.dwhs.net.pid
    mysql 643 /usr/sbin/mysqld –basedir/usr –datadir/var/lib/mysql –plugin-dir/usr/lib64/mysql/plugin –usermysql –log-error/var/lib/mysql/dwhsv160.dwhs.net.err –open-files-limit10000 –pid-file/var/lib/mysql/dwhsv160.dwhs.net.pid
    mysql 638 /usr/sbin/mysqld –basedir/usr –datadir/var/lib/mysql –plugin-dir/usr/lib64/mysql/plugin –usermysql –log-error/var/lib/mysql/dwhsv160.dwhs.net.err –open-files-limit10000 –pid-file/var/lib/mysql/dwhsv160.dwhs.net.pid
    root 17.0 /usr/local/cpanel/whostmgr/bin/whostmgr ./resmysql
    mailman 16.0 /usr/local/cpanel/3rdparty/bin/python -S /usr/local/cpanel/3rdparty/mailman/cron/checkdbs
    sminix84 mastermentalism.org 13.8 [php] <defunct>
    root 12.0 lfd – (child) (PT) checking user processes
    nobody 1.6 /usr/local/apache/bin/httpd -k start -DSSL
    nobody 1.0 /usr/local/apache/bin/httpd -k start -DSSL
    nobody 0.7 /usr/local/apache/bin/httpd -k start -DSSL

    PLEASE HELP ME LET ME KNOW IF YOU CAN FIX THIS. As I said this issue is present at all times but is super bad when using the admin area forcing me to restart mysql via server admin just to get some work done but even this only speeds everything up for a few minutes. My website is very popular and I have a lot of visitors so this is driving me crazy and my bounce rate is skyrocketing!

    Regards,
    Steven

Viewing 3 replies - 1 through 3 (of 3 total)

  • Those errors don’t say much, and unless someone is a really good DB Admin, then they aren’t going to tell us anything at all because there’s no idea of what is causing the issue, just that it’s happening.

    My first and probably biggest suggestion is that you should look at the slow query log in MySQL. That will show you what queries are taking the longest, and that shoudl give you an idea of what’s slowing the server down.

    I’d also suggest looking at a good caching system. There’s plugins for it, but there’s also some great server-side tools that can help a lot as well. That will definately help reduce the load on the DB.

    Error messages can be both confusing and misleading.

    Since you note that you have quite heavy traffic, perhaps you can increase the open-files-limit to more than 10,000 ??

    https://dba.stackexchange.com/questions/18926/open-files-limit

    And, just a note that server performance issues are best solved at server related forums such as linked to.

    Let us know if this helped.

    Error messages can be both confusing and misleading.

    Since you note that you have quite heavy traffic, perhaps you can increase the open-files-limit to more than 10,000 ??

    Indeed! FOr the OP and any future readers:

    The process to increase open_files_limit is different depending upon your OS…
    https://duntuk.com/how-raise-ulimit-open-files-and-mysql-openfileslimit (centos 6, and likely earlier)
    https://ma.ttias.be/increase-open-files-limit-in-mariadb-on-centos-7-with-systemd/

    Google is your friend… so is dba.stackexchange.com and https://community.spiceworks.com/databases and the like… hope you got your issue resolved =)

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘mysql going crazy HELP’ is closed to new replies.