DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) MySQL threads

Info Catalog (mysql.info.gz) MySQL internals (mysql.info.gz) MySQL internals (mysql.info.gz) MySQL test suite
 
 25.1.1 MySQL Threads
 --------------------
 
 The MySQL server creates the following threads:
 
    * The TCP/IP connection thread handles all connection requests and
      creates a new dedicated thread to handle the authentication and
      SQL query processing for each connection.
 
    * On Windows NT there is a named pipe handler thread that does the
      same work as the TCP/IP connection thread on named pipe connect
      requests.
 
    * The signal thread handles all signals.  This thread also normally
      handles alarms and calls `process_alarm()' to force timeouts on
      connections that have been idle too long.
 
    * If `mysqld' is compiled with `-DUSE_ALARM_THREAD', a dedicated
      thread that handles alarms is created.  This is only used on some
      systems where there are problems with `sigwait()' or if you want
      to use the `thr_alarm()' code in your application without a
      dedicated signal handling thread.
 
    * If one uses the `--flush_time=#' option, a dedicated thread is
      created to flush all tables at the given interval.
 
    * Every connection has its own thread.
 
    * Every different table on which one uses `INSERT DELAYED' gets its
      own thread.
 
    * If you use `--master-host', a slave replication thread will be
      started to read and apply updates from the master.
 
 `mysqladmin processlist' only shows the connection, `INSERT DELAYED',
 and replication threads.
 
Info Catalog (mysql.info.gz) MySQL internals (mysql.info.gz) MySQL internals (mysql.info.gz) MySQL test suite
automatically generated byinfo2html