377
Chapter 5. MySQL Server Administration
Table of Contents
5.1. The MySQL Server ............................................................................................................ 377
5.1.1. Server Option and Variable Reference ...................................................................... 378
5.1.2. Server Configuration Defaults ................................................................................... 399
5.1.3. Server Command Options ........................................................................................ 399
5.1.4. Server System Variables .......................................................................................... 425
5.1.5. Using System Variables ........................................................................................... 507
5.1.6. Server Status Variables ........................................................................................... 516
5.1.7. Server SQL Modes .................................................................................................. 534
5.1.8. Server-Side Help ..................................................................................................... 541
5.1.9. Server Response to Signals ..................................................................................... 541
5.1.10. The Shutdown Process .......................................................................................... 542
5.2. MySQL Server Logs ........................................................................................................... 543
5.2.1. The Error Log .......................................................................................................... 543
5.2.2. The General Query Log ........................................................................................... 544
5.2.3. The Binary Log ........................................................................................................ 545
5.2.4. The Slow Query Log ................................................................................................ 548
5.2.5. Server Log Maintenance .......................................................................................... 549
5.3. Running Multiple MySQL Instances on One Machine ........................................................... 550
5.3.1. Setting Up Multiple Data Directories ......................................................................... 552
5.3.2. Running Multiple MySQL Instances on Windows ....................................................... 553
5.3.3. Running Multiple MySQL Instances on Unix .............................................................. 555
5.3.4. Using Client Programs in a Multiple-Server Environment ............................................ 556
End of Product Lifecycle
Active development for MySQL Database Server version 5.0 has ended. Oracle offers
various support offerings which may be of interest. For details and more information, see
the MySQL section of the Lifetime Support Policy for Oracle Technology Products (http://
www.oracle.com/us/support/lifetime-support/index.html). Please consider upgrading to a
recent version.
MySQL Server (
mysqld
) is the main program that does most of the work in a MySQL installation. This
chapter provides an overview of MySQL Server and covers general server administration:
• Server configuration
• The server log files
• Management of multiple servers on a single machine
For additional information on administrative topics, see also:
•
Chapter 6, Security
•
Chapter 7, Backup and Recovery
•
Chapter 16, Replication
5.1. The MySQL Server
mysqld
is the MySQL server. The following discussion covers these MySQL server configuration
topics:
• Startup options that the server supports
• Server system variables
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...