5.1.11. Server Response to Signals

On Unix, signals can be sent to processes. mysqld responds to signals sent to it as follows:

SIGTERM causes the server to shut down.

SIGHUP causes the server to reload the grant tables and to flush tables, logs, the thread cache, and the host cache. These actions are like various forms of the FLUSH statement. The server also writes a status report to the error log that has this format:

Status information:Current dir: /var/mysql/data/Running threads: 0  Stack size: 196608Current locks:Key caches:defaultBuffer_size:       8388600Block_size:           1024Division_limit:        100Age_limit:             300blocks used:             0not flushed:             0w_requests:              0writes:                  0r_requests:              0reads:                   0handler status:read_key:            0read_next:           0read_rnd             0read_first:          1write:               0delete               0update:              0Table status:Opened tables:          5Open tables:            0Open files:             7Open streams:           0Alarm status:Active alarms:   1Max used alarms: 2Next alarm time: 67

On some Mac OS X 10.3 versions, mysqld ignores SIGHUP and SIGQUIT.