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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,
     
  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,
     
  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.
     
  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,
     
  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
     
  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,
    :(
     
  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,
     
  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. :)
     
  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