Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Question Unanswered: MySQL 4.0.21 working fine but why 180+ child process?

    Hi,

    I upgrade MySQL 3.23.56 to 4.0.21 (OS=RedHat 9) successfully. But, I Observed abnormal behavior of MySQL (or may be I am wrong and this is because of features upgrade). Thing is, in MySQL 3.23.56 when I start service, only one process (or hardly 5 child) exist (checked thru command “ps -A | grep mysql*” ) but when I upgraded to MySQL 4.0.21. Above command shows me 180+ mysqld child processes. Is this is a correct behavior (any new change in mysql) or any problem. Logs (/var/log/mysql.log) shows me successful start/stop. MySQL working fine but why 180+ child process?

    -------------------------------------------------
    /etc/my.cnf content is given below:

    [mysqld]
    thread_stack=128K
    datadir=/var/lib/mysql
    port=6306
    socket=/var/lib/mysql/mysql.sock
    max_connections=500
    wait_timeout=28800

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    -----------------------------------------------------

    shell# ps -A | grep mysql*

    >> output is

    6745 ? 00:00:00 mysqld_safe
    6779 ? 00:00:00 mysqld
    6780 ? 00:00:00 mysqld
    6781 ? 00:00:00 mysqld
    6782 ? 00:00:00 mysqld
    6783 ? 00:00:00 mysqld
    6784 ? 00:00:00 mysqld
    6785 ? 00:00:00 mysqld
    6786 ? 00:00:00 mysqld
    6787 ? 00:00:00 mysqld
    6788 ? 00:00:00 mysqld
    6824 ? 00:00:33 mysqld
    7014 ? 00:00:00 mysqld
    7015 ? 00:00:00 mysqld
    7016 ? 00:00:00 mysqld
    ……………………………...
    ……………………………...
    ……………………………...
    ……………………………...
    ……………………………...
    ……………………………...
    7795 ? 00:00:00 mysqld
    7796 ? 00:00:00 mysqld
    9447 ? 00:00:00 mysqld
    9482 ? 00:00:00 mysqld
    10078 ? 00:00:00 mysqld
    10123 ? 00:00:00 mysqld
    11127 ? 00:00:00 mysqld
    11133 ? 00:00:00 mysqld
    11484 ? 00:00:00 mysqld
    11943 ? 00:00:00 mysqld
    13463 ? 00:00:00 mysqld
    13883 ? 00:00:00 mysqld
    13927 ? 00:00:00 mysqld
    14285 ? 00:00:00 mysqld
    14294 ? 00:00:00 mysqld
    14450 ? 00:00:01 mysqld
    14452 ? 00:00:04 mysqld
    15463 ? 00:00:00 mysqld
    15465 ? 00:00:00 mysqld
    15478 ? 00:00:00 mysqld
    15489 ? 00:00:00 mysqld
    15509 ? 00:00:00 mysqld
    15775 ? 00:00:00 mysqld
    15800 ? 00:00:00 mysqld
    16023 ? 00:00:00 mysqld
    16024 ? 00:00:00 mysqld
    16300 ? 00:00:00 mysqld
    16453 ? 00:00:00 mysqld
    16455 ? 00:00:00 mysqld
    16995 ? 00:01:35 mysqld
    18074 ? 00:00:00 mysqld
    18519 ? 00:00:00 mysqld
    18547 ? 00:00:00 mysqld
    18725 ? 00:00:08 mysqld

    Skipping lines here, but total 181 lines.

    Why so many child process?
    Last edited by Azhar Hussain; 09-21-04 at 09:37.

  2. #2
    Join Date
    Oct 2003
    Posts
    706
    The Linux kernel usually shows threads as processes, and unless you use 'ps aux' you might not see the difference. There is a thread for each connection, afaik.

    You do say that the max_connections is '500.' Do you actually need that many?
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

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