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:
    16
    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:
    16
    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:
    16
    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:
    16
    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:
    1
    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:
    16
    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:
    16
    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:
    16
    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:
    16
    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:
    1
    Re: Resolved!!!

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

Share This Page