MySQL 8.0 Reference Manual
v
4.2.4 Using Options on the Command Line ................................................................ 272
4.2.5 Program Option Modifiers ................................................................................. 274
4.2.6 Using Option Files ............................................................................................ 275
4.2.7 Command-Line Options that Affect Option-File Handling ..................................... 280
4.2.8 Using Options to Set Program Variables ............................................................ 281
4.2.9 Option Defaults, Options Expecting Values, and the = Sign ................................. 282
4.2.10 Setting Environment Variables ......................................................................... 285
4.3 MySQL Server and Server-Startup Programs ............................................................... 286
4.3.1 mysqld — The MySQL Server ......................................................................... 286
4.3.2 mysqld_safe — MySQL Server Startup Script ................................................. 287
4.3.3 mysql.server — MySQL Server Startup Script ............................................... 292
4.3.4 mysqld_multi — Manage Multiple MySQL Servers ......................................... 294
4.4 MySQL Installation-Related Programs .......................................................................... 298
4.4.1 comp_err — Compile MySQL Error Message File ............................................ 298
4.4.2 mysql_secure_installation — Improve MySQL Installation Security ........... 299
4.4.3 mysql_ssl_rsa_setup — Create SSL/RSA Files ........................................... 302
4.4.4 mysql_tzinfo_to_sql — Load the Time Zone Tables ................................... 305
4.4.5 mysql_upgrade — Check and Upgrade MySQL Tables ................................... 305
4.5 MySQL Client Programs .............................................................................................. 312
4.5.1 mysql — The MySQL Command-Line Tool ....................................................... 312
4.5.2 mysqladmin — Client for Administering a MySQL Server .................................. 338
4.5.3 mysqlcheck — A Table Maintenance Program ................................................. 347
4.5.4 mysqldump — A Database Backup Program ..................................................... 355
4.5.5 mysqlimport — A Data Import Program ......................................................... 376
4.5.6 mysqlpump — A Database Backup Program ..................................................... 383
4.5.7 mysqlsh — The MySQL Shell ......................................................................... 399
4.5.8 mysqlshow — Display Database, Table, and Column Information ...................... 404
4.5.9 mysqlslap — Load Emulation Client ............................................................... 410
4.6 MySQL Administrative and Utility Programs .................................................................. 419
4.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction Utility ....................................... 419
4.6.2 innochecksum — Offline InnoDB File Checksum Utility .................................... 422
4.6.3 myisam_ftdump — Display Full-Text Index information ..................................... 427
4.6.4 myisamchk — MyISAM Table-Maintenance Utility ............................................. 428
4.6.5 myisamlog — Display MyISAM Log File Contents ............................................ 444
4.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables .................. 445
4.6.7 mysql_config_editor — MySQL Configuration Utility ................................... 451
4.6.8 mysqlbinlog — Utility for Processing Binary Log Files ..................................... 457
4.6.9 mysqldumpslow — Summarize Slow Query Log Files ...................................... 479
4.7 MySQL Program Development Utilities ......................................................................... 481
4.7.1 mysql_config — Display Options for Compiling Clients ................................... 481
4.7.2 my_print_defaults — Display Options from Option Files .............................. 483
4.7.3 resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols ....... 484
4.8 Miscellaneous Programs .............................................................................................. 484
4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output ............ 484
4.8.2 perror — Explain Error Codes ........................................................................ 485
4.8.3 resolveip — Resolve Host name to IP Address or Vice Versa ......................... 486
4.8.4 zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output ......... 486
4.9 MySQL Program Environment Variables ....................................................................... 486
5 MySQL Server Administration ................................................................................................. 489
5.1 The MySQL Server ..................................................................................................... 490
5.1.1 Configuring the Server ...................................................................................... 490
5.1.2 Server Configuration Defaults ........................................................................... 491
5.1.3 Server Option, System Variable, and Status Variable Reference ......................... 492
5.1.4 Server System Variable Reference .................................................................... 533
5.1.5 Server Status Variable Reference ..................................................................... 555
5.1.6 Server Command Options ................................................................................. 569
5.1.7 Server System Variables .................................................................................. 604
5.1.8 Using System Variables .................................................................................... 739
评论0