mysqld8
The mysql server
Usage
mysqld [options]
Overview
mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. It does not spawn additional processes. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files.
Note
Some installation packages contain a debugging version of the server named mysqld-debug. Invoke this version instead of mysqld for debugging support, memory allocation checking, and trace file support (see Section 7.9.1.2, “Creating Trace Files”).
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients.
The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:
mysqld --verbose --help
MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that provide information about its operation. You can monitor these status variables to access runtime performance characteristics.
For a full description of MySQL Server command options, system variables, and status variables, see Section 7.1, “The MySQL Server”. For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing MySQL.
Releases
12 releases since Debian 3.1 (Sarge); the text changed 11 times.
--ansi until Debian 3.1 (Sarge);
--big-tables until Debian 3.1 (Sarge);
--bind-address until Debian 3.1 (Sarge);
--character-sets-dir until Debian 3.1 (Sarge);
--chroot until Debian 3.1 (Sarge);
--default-character-set until Debian 3.1 (Sarge);
--default-table-type until Debian 3.1 (Sarge);
--delay-key-write-for-all-tables until Debian 3.1 (Sarge);
--enable-locking until Debian 3.1 (Sarge);
--flush until Debian 3.1 (Sarge);
--init-file until Debian 3.1 (Sarge);
--log-isam until Debian 3.1 (Sarge);
--log-long-format until Debian 3.1 (Sarge);
--log-slow-queries until Debian 3.1 (Sarge);
--log-update until Debian 3.1 (Sarge);
--low-priority-updates until Debian 3.1 (Sarge);
--memlock until Debian 3.1 (Sarge);
--one-thread until Debian 3.1 (Sarge);
--pid-file until Debian 3.1 (Sarge);
--safe-mode until Debian 3.1 (Sarge);
--secure until Debian 3.1 (Sarge);
--skip-concurrent-insert until Debian 3.1 (Sarge);
--skip-delay-key-write until Debian 3.1 (Sarge);
--skip-host-cache until Debian 3.1 (Sarge);
--skip-locking until Debian 3.1 (Sarge);
--skip-name-resolve until Debian 3.1 (Sarge);
--skip-networking until Debian 3.1 (Sarge);
--skip-new until Debian 3.1 (Sarge);
--skip-show-database until Debian 3.1 (Sarge);
--skip-thread-priority until Debian 3.1 (Sarge);
--socket until Debian 3.1 (Sarge).