MySQL 8 Innodb – Architecture
MySQL – Database Script & Documentation Links, Cheat Sheet Downloads
MySQL DBA Scripts
• Anvesh Patel’s – MySQL DBA Scripts
MySQL DBA Articles
• Planet MySQL – DBA Articles
• How to Monitor MySQL Databases
Unix Commands – Cheat Sheet
• Unix Commands for MySQL DBAs
MySQL Database – Documentation Link
• MySQL Documentation Hub – All Releases
MySQL Database – Tutorial Link
• Tutorials Point – MySQL Tutorials
MySQL Database – Cheat Sheet Links
• MySQL Cheat Sheet 1
• MySQL Cheat Sheet 2
Server Programs
Client Programs
- mysql — the MySQL Command-Line Client (main app)
- mysqladmin — MySQL Server Administration Program
- mysqlcheck — Table Maintenance Program
- mysqldump — Database Backup Program
- mysqlimport — Data Import Program
- mysqlpump — Database Backup Program
- mysqlshow — Display Database, Table, and Column Information
- mysqlslap — Load Emulation Client
Administrative and Utility Programs
- ibd2sdi — InnoDB Tablespace SDI Extraction Utility
- innochecksum — Offline InnoDB File Checksum Utility
- myisam_ftdump — Display Full-Text Index information
- myisamchk — MyISAM Table-Maintenance Utility
- myisamlog — Display MyISAM Log File Contents
- myisampack — Generate Compressed, Read-Only MyISAM Tables
- mysql_config_editor — MySQL Configuration Utility
- mysql_migrate_keyring — Keyring Key Migration Utility
- mysqlbinlog — Utility for Processing Binary Log Files
- mysqldumpslow — Summarize Slow Query Log Files
MySQL Environment Variables
| Variable | Description |
|---|---|
AUTHENTICATION_LDAP_CLIENT_LOG |
Client-side LDAP authentication logging level. |
AUTHENTICATION_PAM_LOG |
PAM authentication plugin debug logging settings. |
CC |
The name of your C compiler (for running CMake). |
CXX |
The name of your C++ compiler (for running CMake). |
CC |
The name of your C compiler (for running CMake). |
DBI_USER |
The default user name for Perl DBI. |
DBI_TRACE |
Trace options for Perl DBI. |
HOME |
The default path for the mysql history file is $HOME/.mysql_history. |
LD_RUN_PATH |
Used to specify the location of libmysqlclient.so. |
LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN |
Enable mysql_clear_password authentication plugin; see Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”. |
LIBMYSQL_PLUGIN_DIR |
Directory in which to look for client plugins. |
LIBMYSQL_PLUGINS |
Client plugins to preload. |
MYSQL_DEBUG |
Debug trace options when debugging. |
MYSQL_GROUP_SUFFIX |
Option group suffix value (like specifying --defaults-group-suffix). |
MYSQL_HISTFILE |
The path to the mysql history file. If this variable is set, its value overrides the default for $HOME/.mysql_history. |
MYSQL_HISTIGNORE |
Patterns specifying statements that mysql should not log to $HOME/.mysql_history, or syslog if --syslog is given. |
MYSQL_HOME |
The path to the directory in which the server-specific my.cnf file resides. |
MYSQL_HOST |
The default host name used by the mysql command-line client. |
MYSQL_OPENSSL_UDF_DH_BITS_THRESHOLD |
Maximum key length for create_dh_parameters(). See Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”. |
MYSQL_OPENSSL_UDF_DSA_BITS_THRESHOLD |
Maximum DSA key length for create_asymmetric_priv_key(). See Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”. |
MYSQL_OPENSSL_UDF_RSA_BITS_THRESHOLD |
Maximum RSA key length for create_asymmetric_priv_key(). See Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”. |
MYSQL_PS1 |
The command prompt to use in the mysql command-line client. |
MYSQL_PWD |
The default password when connecting to mysqld. Using this is insecure. See note following table. |
MYSQL_TCP_PORT |
The default TCP/IP port number. |
MYSQL_TEST_LOGIN_FILE |
The name of the .mylogin.cnf login path file. |
MYSQL_TEST_TRACE_CRASH |
Whether the test protocol trace plugin crashes clients. See note following table. |
MYSQL_TEST_TRACE_DEBUG |
Whether the test protocol trace plugin produces output. See note following table. |
MYSQL_UNIX_PORT |
The default Unix socket file name; used for connections to localhost. |
MYSQLX_TCP_PORT |
The X Plugin default TCP/IP port number. |
MYSQLX_UNIX_PORT |
The X Plugin default Unix socket file name; used for connections to localhost. |
NOTIFY_SOCKET |
Socket used by mysqld to communicate with systemd. |
PATH |
Used by the shell to find MySQL programs. |
PKG_CONFIG_PATH |
Location of mysqlclient.pc pkg-config file. See note following table. |
TMPDIR |
The directory in which temporary files are created. |
TZ |
This should be set to your local time zone. See Section B.3.3.7, “Time Zone Problems”. |
UMASK |
The user-file creation mode when creating files. See note following table. |
UMASK_DIR |
The user-directory creation mode when creating directories. See note following table. |
USER |
The default user name on Windows when connecting to mysqld. |
MySQL Version History
| Release | General availability | Latest minor version | Latest release | End of support |
|---|---|---|---|---|
| 5.1 | 14 November 2008 | 5.1.73 | 2013-12-03 | Dec 2013 |
| 5.5 | 3 December 2010 | 5.5.62 | 2018-10-22 | Dec 2018 |
| 5.6 | 5 February 2013 | 5.6.51 | 2021-01-20 | Feb 2021 |
| 5.7 | 21 October 2015 | 5.7.33 | 2021-01-18 | Oct 2023 |
| 8.0 | 19 April 2018 | 8.0.23 | 2021-01-18 | Apr 2026 |
