Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    84

    Question Is this normal ?

    I noticed that my ps -aux shows lots of these skip-locking
    bellow, is that normal?

    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    root 19666 0.0 0.1 6756 1948 ? S 22:37 0:01 /usr/sbin/sshd
    root 19718 0.0 0.1 5240 1428 pts/0 S 22:37 0:00 -bash
    mysql 21254 0.1 7.0 646568 72452 ? S 23:02 0:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    nobody 21358 0.0 0.5 44124 5732 ? S 23:03 0:02 /usr/local/apache/bin/httpd -DSSL
    mysql 21550 0.0 7.0 646568 72452 ? S 23:04 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 22199 0.5 7.0 646568 72452 ? S 23:14 0:15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 22367 0.0 7.0 646568 72452 ? S 23:16 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    nobody 22436 0.1 0.5 44164 5752 ? S 23:16 0:03 /usr/local/apache/bin/httpd -DSSL
    nobody 22438 0.0 0.5 44164 5544 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22451 0.0 0.5 44188 5768 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    nobody 22452 0.0 0.5 44340 5980 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22473 0.0 0.5 43928 5320 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22474 0.0 1.1 50640 12064 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    nobody 22475 0.0 0.5 44208 5744 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22480 0.0 0.5 44220 5784 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    nobody 22484 0.0 0.5 44324 5536 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22485 0.1 0.5 44300 5640 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    nobody 22517 0.0 0.5 44256 5828 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22518 0.0 0.5 44260 5888 ? S 23:16 0:01 /usr/local/apache/bin/httpd -DSSL
    nobody 22519 0.1 0.5 44256 5760 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    nobody 22535 0.0 0.5 44292 5788 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    nobody 22536 0.0 0.5 44060 5608 ? S 23:16 0:02 /usr/local/apache/bin/httpd -DSSL
    mysql 22887 0.0 7.0 646568 72452 ? S 23:21 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 23499 0.0 7.0 646568 72452 ? S 23:33 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 23508 0.0 7.0 646568 72452 ? S 23:33 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 23646 0.1 0.0 0 0 ? Z 23:34 0:02 [mysqld <defunct>]
    mysql 23787 0.0 7.0 646568 72452 ? S 23:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 23814 0.1 7.0 646568 72452 ? S 23:38 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 23859 0.0 7.0 646568 72452 ? S 23:39 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 23867 0.1 7.0 646568 72452 ? S 23:39 0:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 24016 0.0 7.0 646568 72452 ? S 23:41 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 24085 0.0 7.0 646568 72452 ? S 23:42 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 24131 0.0 7.0 646568 72452 ? S 23:42 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking
    mysql 24170 0.0 7.0 646568 72452 ? S 23:42 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/
    mysql --user=mysql --pid-file=/var/lib/mysql/server1.mydomain.com.pid --skip-locking

  2. #2
    Join Date
    Apr 2003
    Posts
    959
    Yes, it appears to mine too..but not from ps -aux~

    But I am a "no no" in MySQL..need someone to tell me too..is that normal?

  3. #3
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,294
    yes thats normal
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •