Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

important -mysql problem- down

Discussion in 'Workarounds and Optimization' started by morteza3245, Oct 30, 2013.

  1. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    138
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hi
    im sorry for not good subject, forgive me

    today i see my site's not load, after check, i see mysql is down, then try for start and restart,
    then i see a table from basic site (myself hosting site) have 38GB size, (that was size from log sms)

    then i try faster empty that,

    now my problem is:
    when i suspend same user, all other sites work fine,
    but when i unsuspend same user, i see Slowly all site have error (cant connect to database), then i suspend same user, i see faster site's work fine.

    Please help me

    i do below action, but without different:

    but again i have same problem,

    i have below log:



    Please help me.

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 morteza3245, Oct 30, 2013
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you let us know the contents of your /etc/my.cnf file?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Oct 30, 2013
  3. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    138
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hi
    below is my.cnf config:

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 morteza3245, Oct 30, 2013
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    If the issue only occurs when one account is active, it's likely that account that is causing MySQL to fail. You can run the following command when the account is active to see what tables are causing the problem:

    Code:
    mysqladmin processlist;
    Also, the following thread is helpful for obtaining statistics that will better help others give you advice on optimizing the /etc/my.cnf values:

    mysqlmymonlite.sh server stats gathering tool for cPanel Server

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Oct 30, 2013
  5. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    138
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Ah, yes, i see same user have much mysql sleep, see below pleaase:

    Note: this "sameuser_new" is same user have problem

    what i must do?


    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 morteza3245, Oct 30, 2013
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    You will likely want to suspend the account and restart MySQL. Or, contact the user to alert them of the issue with their database. Otherwise, the following thread is helpful for obtaining statistics that will better help others give you advice on optimizing the /etc/my.cnf values:

    mysqlmymonlite.sh server stats gathering tool for cPanel Server

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Oct 30, 2013
  7. morteza3245

    morteza3245 Well-Known Member

    Joined:
    Sep 16, 2013
    Messages:
    138
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Thanks, user is for myself
    that was very very good 5years old, now have this problem
    how i can know which table is sleep?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 morteza3245, Oct 30, 2013
    Last edited: Oct 30, 2013
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    The table is not listed. You will need to manually review the database. You will likely find one specific table with a large size or with several records. phpMyAdmin is useful for this if you are not comfortable on the command line.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Oct 30, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - important mysql problem
  1. hendranata

    How important is CGI Access?

    hendranata, Sep 7, 2017, in forum: Security
    Replies:
    2
    Views:
    880
    cPanelMichael
    Sep 12, 2017
  2. enginestar

    How important is symlink protection?

    enginestar, Jul 12, 2017, in forum: Security
    Replies:
    6
    Views:
    844
    quizknows
    Jul 14, 2017
  3. LeGastronome

    Backup important files and folder on rescue mode

    LeGastronome, Mar 24, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    960
    cPanelMichael
    Mar 24, 2017
  4. Deker

    New Thread MySQL Governor not working properly

    Deker, Oct 20, 2018 at 12:29 PM, in forum: CloudLinux
    Replies:
    0
    Views:
    51
    Deker
    Oct 20, 2018 at 12:29 PM
  5. inteldigital

    New Thread MySQL desynchronising passwords with WHM/PhpMyAdmin

    inteldigital, Oct 19, 2018 at 6:54 PM, in forum: General Discussion
    Replies:
    3
    Views:
    83
    24x7server
    Oct 22, 2018 at 8:39 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice