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.

Skip Locking

Discussion in 'General Discussion' started by lifeisboost, May 2, 2003.

  1. lifeisboost

    lifeisboost Member

    Joined:
    Mar 7, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hello, This is a first time post here please forgive me as i am also still new to running a server.

    I have searched for this problem and have not come up with a way or reason why skip-locking is used.

    The problem is skip locking is using 8 pids in WHM and eating up 7.9% mem,

    I only have 40 sites on my server and 2 DBS, even if i try to kill the proccesses they start right back up. any help is appreciated.
     
  2. jackal

    jackal Well-Known Member
    PartnerNOC

    Joined:
    Feb 23, 2002
    Messages:
    708
    Likes Received:
    0
    Trophy Points:
    16
    We are having same problem anyone got any ideas? Eating 25% of the memory up.

    /usr/sbin/mysqld--basedir=/--datadir=/var/lib/mysql--user=mysql--pid-file=/var/lib/mysql/dfr.max.net.pid--skip-locking

    cPanel.net Support Ticket Number:
     
  3. sqsisa

    sqsisa Well-Known Member

    Joined:
    Apr 8, 2003
    Messages:
    97
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Bay Area, CA
    Bump!

    cPanel.net Support Ticket Number:
     
  4. jackal

    jackal Well-Known Member
    PartnerNOC

    Joined:
    Feb 23, 2002
    Messages:
    708
    Likes Received:
    0
    Trophy Points:
    16
    Top Process %CPU 85.4 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.jone.net.pid --skip-locking
    Top Process %CPU 83.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.jone.net.pid --skip-locking
    Top Process %CPU 82.3 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.jone.net.pid --skip-locking

    cPanel.net Support Ticket Number:
     
  5. TogaDave

    TogaDave Well-Known Member

    Joined:
    Apr 13, 2003
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    Same here :(

    cPanel.net Support Ticket Number:
     
  6. erwinfa

    erwinfa Well-Known Member

    Joined:
    Jun 14, 2003
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    0
    I have the same issue .. And these processes take about 80% memory.

    Anyone get the same issue, and what does it means ? I've used mysql 4.0.15. This made my load server increase around 10, sometimes around 80.

    How to solved this problem ?

    cPanel.net Support Ticket Number:
     
  7. jonx

    jonx Member

    Joined:
    Sep 6, 2002
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I'm experiencing this issue as well. Are there any fixes to this? Load goes up to 100 sometimes due to this :(

    cPanel.net Support Ticket Number:
     
  8. equivity

    equivity Well-Known Member

    Joined:
    Aug 12, 2003
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Daytona Beach, Florida
    same thing here, and nothing seems to be found to solve that on the forums..
     
  9. Mallclerks

    Mallclerks Member

    Joined:
    Aug 3, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Did anyone ever find out whats causing this? As its also killing my server and keeps the load above 3.0 right now, When it should be below .5 :(
     
  10. vishal

    vishal Well-Known Member

    Joined:
    Jan 28, 2003
    Messages:
    340
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Same HERE too :confused:

    Any Solution to this ?????

    Degrade to Mysql 3.x will help ?????

    Thanks,
     
  11. sfield

    sfield Active Member

    Joined:
    Sep 8, 2003
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Anyone have a solution to this?
     
  12. @home

    @home Well-Known Member

    Joined:
    Nov 5, 2003
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    this is something cpanel needs

    But if you want less loads.

    PM or email me i will help you ;)
     
  13. icehosting

    icehosting Well-Known Member

    Joined:
    Dec 22, 2002
    Messages:
    60
    Likes Received:
    0
    Trophy Points:
    6
    Hi,
    i have the same problem. mysql use all the cpu power. I not have any hard forum or something hard. How i can find the person who overload the mysql?
    in the report i have see like this
    Top Process %CPU 85.4 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.jone.net.pid --skip-locking
    Top Process %CPU 83.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.jone.net.pid --skip-locking
    Top Process %CPU 82.3 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.jone.net.pid --skip-locking
     
  14. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    I have a couple of servers doing the same thing, and i noticed this discussion

    so i will as myself to the

    "me too" list

    has anyone any advice on this issue?
     
  15. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    What are your server specs and what is in
    /etc/.my.cnf?
     
  16. Lippy

    Lippy Active Member

    Joined:
    Jan 9, 2003
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Check out this guide to fix that, its more from mysql not being optimized. I normally only add these lines to start with, but look at the guide as well.


    Guide: http://forums.ev1servers.net/showthread.php?s=&threadid=20983

    /etc/my.cnf for mysql

    Then restart mysql by typing /etc/rc.d/init.d/mysql restart
     
  17. shizzle

    shizzle Member

    Joined:
    Sep 26, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    script problem

    guys i have had the same problem,
    plese check your users scripts that open a connection to mysql, the connection has to be closed at the end of the script.

    some lame progarammers dont do this... it causes then huge server loads

    if it doesn't help, then check /etc/my.cnf , it has to be set properly...

    :)
     
  18. gunmuse

    gunmuse Well-Known Member

    Joined:
    Jul 3, 2003
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    New Mexico

    Why not post it in the forums. That is what they are for. Bitching about a problem is only half of the point. A resolution in the thread is also nice.
     
  19. project3

    project3 Member

    Joined:
    Feb 7, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Me too

    So far Im very disapointed at the way nothing gets fixed around here. I have the same problem as well as all these people but yet no one has posted an answer that solves the problem.

    And one person acts like they know but you have to pm them what this, do they need to feel that special?

    I guess the answer to this problem is install plesk.
     
  20. DigitalN

    DigitalN Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    420
    Likes Received:
    1
    Trophy Points:
    18
    Not sure how you get that cPanel is responsible for your MysQL server administration and optimisation, you might be better to look at www.mysql.com for tips on how to admin a MysQL server.

    I don't think much to plesk, doesn't have the flexibility of cpanel, or the scripts and functions that cPanel does - Still each to their own :)

    Sorry if that seems harsh, but the plesk comment just just summed up your attitude I thought - cPanel isn't a server admin - you are or people you hire to do that task are.
    Around here, you get help from people who provide tips etc for free, lots of good comes out of these forums - to the right people with the right attitude.

    Not meant to flame you - just to make you think :)

    Good luck in your endeavours.
     
Loading...

Share This Page