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!

mysql increasing server load....

Discussion in 'General Discussion' started by mitul, Apr 26, 2003.

  1. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    I am using RH 7.3 with apache 1.3.27 and mysql 4.x.

    Mysql status...

    CPU MEM Process
    mysql 62.51 98.43 0.0

    How do I control this?

    Thank you,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    When I checked the processlist I found one db is locking up mysql (creating many lock tables). Could this be the problem?

    Thank you,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. carlgm

    carlgm Well-Known Member

    Joined:
    Mar 25, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    England, UK
    Hello,

    Could you login to SSH as root and

    And copy & paste the contents of that file please.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    contents of /etc/my.cnf

    ================================
    [mysqld]
    set-variable = max_connections=500
    =================================

    Thank you,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Jimbo_Jones

    Jimbo_Jones Registered

    Joined:
    Feb 8, 2003
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    do a search on optimizing my.cnf, heere and @ rackshack forum
     
  6. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    DB Locked

    Hello,

    When i did mysqladmin processlist this is what it showed me!!

    Id | User | Host | db | State
    700 user1
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    DB Locked

    Hello,

    When i did mysqladmin processlist this is what it showed me!!

    Id | User | Host | db | State
    700 user1 localhost mydb1 locked
    701 user1 localhost mydb1 locked
    702 user1 localhost mydb1 locked
    703 user1 localhost mydb1 locked

    uptime:
    12:29pm up 3 days, 12:25, 1 user, load average: 131.82, 10.43, 14.71

    mysqld consuming cup resource!!

    What's up?????


    Regards,
    :(
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. mitul

    mitul Well-Known Member

    Joined:
    Feb 8, 2003
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    166
    Resolved!!!

    :) Resolved

    2:49pm up 3 days, 14:44, 0 users, load average: 0.83, 0.84, 0.89

    Regards,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. carlgm

    carlgm Well-Known Member

    Joined:
    Mar 25, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    England, UK
    Yes you should have a lot more in your my.cnf file. :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. Shi

    Shi Member

    Joined:
    Feb 19, 2002
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    301
    Re: Resolved!!!

    Hi :)
    How did you resolve the issue?
    I'm having a similar one :)
    Thanks
     
Loading...

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.
    Dismiss Notice