SQL skip-external-locking using high CPU & Memory usage - What is it?

Discussion in 'Apache' started by webdesigner, Jan 10, 2008.

  1. #1
    My Top Processes are always:


    Top Process %CPU 15.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/host.***.com.pid --skip-external-locking

    Top Process %CPU 15.4 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/host.***com.pid --skip-external-locking

    Top Process %CPU 15.3 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/host.***.com.pid --skip-external-locking


    What is this and is it normal? Thanks in advance.
     
    webdesigner, Jan 10, 2008 IP
  2. S2X

    S2X Active Member

    Messages:
    508
    Likes Received:
    22
    Best Answers:
    0
    Trophy Points:
    58
    #2
    I was just wondering the same thing and came across this page in google... Anyone have an answer to this?
     
    S2X, Jul 24, 2008 IP
  3. invisible121

    invisible121 Banned

    Messages:
    357
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    This error is also killing my VPS.. what is this anyway? thanks
     
    invisible121, Sep 22, 2008 IP
  4. The Universes

    The Universes Peon

    Messages:
    187
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    skip-external-locking is enabled by default on MySQL 4.0+. You don't need to worry about that at all.
     
    The Universes, Sep 23, 2008 IP
  5. desiboy

    desiboy Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I am having the same problem of skip-external-locking process uses high cpu for hight cpu load...is there anyway to disable it..and if I did it what's the impact...can anyone please explain
     
    desiboy, Jan 21, 2009 IP
  6. invisible121

    invisible121 Banned

    Messages:
    357
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If you're running wordpress, check your plugins, a single plugin could kill your server. I have a blog with more than 15,000 entries, i'm using the "Related Posts" plugin and that killed my blog. Make sure you install wp-cache too. :)
     
    invisible121, Jan 27, 2009 IP