1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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

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

0
  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