Results 1 to 4 of 4

Thread: mysql <defunct>

  1. #1
    Join Date
    Mar 2003
    Posts
    84

    Lightbulb mysql <defunct>

    Does anyone know a list of common causes to mysql zomie processes? I'm currently see mysql <defunct> in "top"

    Please help. Thank you

  2. #2
    Join Date
    Nov 2000
    Location
    localhost
    Posts
    3,510
    Please post your system specifications, your usage and your /etc/my.cnf also a dump of open connections see mysqladmin
    MattF - Since the start..

  3. #3
    Join Date
    Dec 2001
    Location
    NYC, NY
    Posts
    798
    there really is no way to kill a defunct process. It means somehow the parent died and didn't kill its child processes.

  4. #4
    Join Date
    Mar 2003
    Posts
    84

    Exclamation

    Originally posted by MattF
    Please post your system specifications, your usage and your /etc/my.cnf also a dump of open connections see mysqladmin
    System Spec
    P4 2.4 1G RAM 80G 7200RPM
    WHM 9.2.0 cPanel 9.3.0-R5
    RedHat 9 - WHM X v3.1.0
    apache 1.3.29
    mysql (4.0.18-standard)


    my.cnf

    [client]
    port = 3306
    socket = /var/lib/mysql/mysql.sock

    [mysqld]
    max_connections=700
    safe-show-database
    skip-locking
    skip-innodb
    key_buffer = 256M
    max_allowed_packet = 1M
    sort_buffer_size = 1M
    read_buffer_size = 1M
    myisam_sort_buffer_size = 64M
    table_cache = 1024
    query_cache_size = 32M
    thread_cache = 16
    thread_concurrency = 16

    [isamchk]
    key_buffer = 128M
    sort_buffer_size = 128M
    read_buffer = 2M
    write_buffer = 2M

    [myisamchk]
    key_buffer = 128M
    sort_buffer_size = 128M
    read_buffer = 2M
    write_buffer = 2M

    [mysqlhotcopy]
    interactive-timeout

    open connections
    How do I get this? I looked into man mysqladmin but did not know what command to use. Can you help?


    I get "httpd <defunct>" quite often and most of the time the domain log file size reach 2G limit; so when I get the "httpd <defunct>" , the first thing I check it the domain log file.
    I'm expecting in the "mysql <defunct>", there must be one or a list of common causes that I do a quick check. Anyone know what they are?

    Thank you in advance.

Posting Permissions

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