Let us understand about ‘mysqld’, the MySQL server −
The mysqld is also known as MySQL Server. It is a single multithreaded program that does most of the work in a MySQL installation. It doesn’t spawn additional processes.
MySQL Server helps manage the access to the MySQL data directory which contains databases and tables. The data directory is the default location for other information like log files and status files.
Note − Certain installation packages may contain a debugging version of the server by the name mysqld-debug.
This version can be invoked instead of the mysqld for debugging support, memory allocation checking, as well as trace file support.
When MySQL server starts, it will listen to the network connections from client programs as well as help manage the access to databases on behalf of these clients.
To see options specified at startup, the below command can be run −
shell> mysqld --verbose --help
MySQL Server has many system variables that can affect its operation as it runs. System variables can be set up during server startup. Many of them can be changed during runtime so as to effect dynamic server reconfiguration.
MySQL Server has a set of status variables that help provide information about its operation. The status of these variables can be monitored to access runtime performance characteristics.