(mysql.info) server-side-overview
Info Catalog
(mysql.info) database-administration
(mysql.info) database-administration
(mysql.info) mysqld
5.1 Overview of Server-Side Programs
====================================
The MySQL server, `mysqld', is the main program that does most of the
work in a MySQL installation. The server is accompanied by several
related scripts that perform setup operations when you install MySQL or
that assist you in starting and stopping the server. This section
provides an overview of the server and related programs. The following
sections provide more detailed information about each of these programs.
Each MySQL program takes many different options. Most programs provide
a -help option that you can use to get a description of the program's
different options. For example, try `mysqld --help'.
You can override default option values for MySQL programs by specifying
options on the command line or in an option file.
program-options.
The following list briefly describes the MySQL server and
server-related programs:
* `mysqld'
The SQL daemon (that is, the MySQL server). To use client
programs, `mysqld' must be running, because clients gain access to
databases by connecting to the server. See mysqld.
* `mysqld-max'
A version of the server that includes additional features. See
mysqld-max.
* `mysqld_safe'
A server startup script. `mysqld_safe' attempts to start
`mysqld-max' if it exists, and `mysqld' otherwise. See
mysqld-safe.
* `mysql.server'
A server startup script. This script is used on systems that use
System V-style run directories containing scripts that start
system services for particular run levels. It invokes
`mysqld_safe' to start the MySQL server. See mysql-server.
* `mysqld_multi'
A server startup script that can start or stop multiple servers
installed on the system. See mysqld-multi. As of MySQL
5.0.3 (Unix-like systems) or 5.0.13 (Windows), an alternative to
`mysqld_multi' is `mysqlmanager', the MySQL Instance Manager.
instead of `mysqld_multi'. See instance-manager.
* `mysql_install_db'
This script creates the MySQL database and initializes the grant
tables with default privileges. It is usually executed only once,
when first installing MySQL on a system. See
unix-post-installation.
* `mysql_fix_privilege_tables'
This program is used after a MySQL upgrade operation. It updates
the grant tables with any changes that have been made in newer
versions of MySQL. See mysql-fix-privilege-tables.
Note: As of MySQL 5.0.19, this program has been superseded by
`mysql_upgrade'.
* `mysql_upgrade'
This program is used after a MySQL upgrade operation. It checks
tables for incompatibilities and repairs them if necessary, and
updates the grant tables with any changes that have been made in
newer versions of MySQL. See mysql-upgrade.
* `mysqlmanager'
The MySQL Instance Manager, a program for monitoring and managing
MySQL servers. See instance-manager.
There are several other programs that are run on the server host:
* `make_binary_distribution'
This program makes a binary release of a compiled MySQL. This
could be sent by FTP to `/pub/mysql/upload/' on `ftp.mysql.com'
for the convenience of other MySQL users.
Info Catalog
(mysql.info) database-administration
(mysql.info) database-administration
(mysql.info) mysqld
automatically generated byinfo2html