MySQL 9.1 Reference Manual
6.2.2 Specifying Program Options .............................................................................. 248
6.2.3 Command Options for Connecting to the Server ................................................ 262
6.2.4 Connecting to the MySQL Server Using Command Options ................................ 274
6.2.5 Connecting to the Server Using URI-Like Strings or Key-Value Pairs ................... 277
6.2.6 Connecting to the Server Using DNS SRV Records ........................................... 284
6.2.7 Connection Transport Protocols ........................................................................ 285
6.2.8 Connection Compression Control ...................................................................... 286
6.2.9 Setting Environment Variables .......................................................................... 290
6.3 Server and Server-Startup Programs ........................................................................... 291
6.3.1 mysqld — The MySQL Server .......................................................................... 291
6.3.2 mysqld_safe — MySQL Server Startup Script .................................................... 291
6.3.3 mysql.server — MySQL Server Startup Script .................................................... 300
6.3.4 mysqld_multi — Manage Multiple MySQL Servers .............................................. 302
6.4 Installation-Related Programs ...................................................................................... 307
6.4.1 comp_err — Compile MySQL Error Message File .............................................. 307
6.4.2 mysql_secure_installation — Improve MySQL Installation Security ...................... 309
6.4.3 mysql_tzinfo_to_sql — Load the Time Zone Tables ............................................ 315
6.5 Client Programs .......................................................................................................... 315
6.5.1 mysql — The MySQL Command-Line Client ...................................................... 315
6.5.2 mysqladmin — A MySQL Server Administration Program ................................... 359
6.5.3 mysqlcheck — A Table Maintenance Program ................................................... 375
6.5.4 mysqldump — A Database Backup Program ..................................................... 389
6.5.5 mysqlimport — A Data Import Program ............................................................. 426
6.5.6 mysqlshow — Display Database, Table, and Column Information ........................ 440
6.5.7 mysqlslap — A Load Emulation Client ............................................................... 451
6.6 Administrative and Utility Programs .............................................................................. 468
6.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction Utility ........................................... 468
6.6.2 innochecksum — Offline InnoDB File Checksum Utility ....................................... 473
6.6.3 myisam_ftdump — Display Full-Text Index information ....................................... 480
6.6.4 myisamchk — MyISAM Table-Maintenance Utility .............................................. 481
6.6.5 myisamlog — Display MyISAM Log File Contents .............................................. 500
6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables .................... 501
6.6.7 mysql_config_editor — MySQL Configuration Utility ........................................... 507
6.6.8 mysql_migrate_keyring — Keyring Key Migration Utility ...................................... 514
6.6.9 mysqlbinlog — Utility for Processing Binary Log Files ......................................... 523
6.6.10 mysqldumpslow — Summarize Slow Query Log Files ....................................... 553
6.7 Program Development Utilities ..................................................................................... 556
6.7.1 mysql_config — Display Options for Compiling Clients ....................................... 556
6.7.2 my_print_defaults — Display Options from Option Files ...................................... 557
6.8 Miscellaneous Programs .............................................................................................. 559
6.8.1 perror — Display MySQL Error Message Information .......................................... 559
6.9 Environment Variables ................................................................................................. 559
6.10 Unix Signal Handling in MySQL ................................................................................. 562
7 MySQL Server Administration ................................................................................................. 563
7.1 The MySQL Server ..................................................................................................... 564
7.1.1 Configuring the Server ...................................................................................... 565
7.1.2 Server Configuration Defaults ........................................................................... 566
7.1.3 Server Configuration Validation ......................................................................... 566
7.1.4 Server Option, System Variable, and Status Variable Reference ......................... 567
7.1.5 Server System Variable Reference .................................................................... 616
7.1.6 Server Status Variable Reference ..................................................................... 642
7.1.7 Server Command Options ................................................................................. 660
7.1.8 Server System Variables .................................................................................. 684
7.1.9 Using System Variables .................................................................................... 840
7.1.10 Server Status Variables .................................................................................. 871
7.1.11 Server SQL Modes ......................................................................................... 897
7.1.12 Connection Management ................................................................................ 909
7.1.13 IPv6 Support .................................................................................................. 916
v
