12th Mar 2010

-lots- of mysql processes running?

  • aloa :)

    i am a little bit confused after i had a look at the process list via ps -waux .. when i saw there were like 20-25 mysql processes running. is this normal or something odd going on? :)

    root 1187 0.0 0.1 2480 1252 ? S Jan25 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var
    mysql 1243 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1263 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1264 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1678 0.0 1.9 24428 19824 ? S Jan25 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1680 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1681 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1733 0.0 1.9 24428 19824 ? S Jan25 0:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1734 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1735 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1736 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1737 0.0 1.9 24428 19824 ? S Jan25 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 1739 0.0 1.9 24428 19824 ? S Jan25 0:24 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 2908 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 2909 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 3141 0.0 1.9 24428 19824 ? S Jan26 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 3199 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 3218 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 3219 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 3223 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 3405 0.0 1.9 24428 19824 ? S Jan26 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 11015 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 11058 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 11095 0.0 1.9 24428 19824 ? S Jan27 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 11116 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 11117 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16058 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16059 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16060 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16061 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16062 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16063 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16064 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 16068 0.0 1.9 24428 19824 ? S Jan27 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 17593 0.0 1.9 24428 19824 ? S 03:48 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 17594 0.0 1.9 24428 19824 ? S 03:48 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
    mysql 17602 0.0 1.9 24428 19824 ? S 04:00 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --


    cheers,
    jörg


  • yes this is fairly normally you do have persistent connections ebaled in config.php pconnects = 1 ?


  • MySQL is multi-threaded, so as more connections come in, more processes are spawned.


  • yep :)

    okidoki.. i was just wondering....

    thanks once again :D







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about -lots- of mysql processes running? , Please add it free.

    Posted by smith under enart.88083.com |

    Procom Reports Third-Quarter and Nine-Month Results
    Nortel Unveils Vision, Strategy for Israeli High-Performance Net