https://dev.mysql.com/mysql-commands.html
For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for `help'. mysql sends each SQL statement that you issue ...
https://dev.mysql.com/mysql-innodb-cluster-production-deployment.html
The command returns a descriptive text message about the operation's result. When working in a production environment, the MySQL server instances which make up an InnoDB cluster run on multiple host machines as part of a network rather than on ...
https://dev.mysql.com/mysql-tips.html
For example, longer text values that include newlines often are much easier to read with vertical output: mysql> SELECT * FROM mails WHERE LENGTH(txt) < 300 LIMIT 300,1\G *************************** 1. This section provides information about ...
https://dev.mysql.com/mysqlbinlog-row-events.html
Character set information is not available in the binary log, which affects string column display: There is no distinction made between corresponding binary and nonbinary string types (BINARY and CHAR, VARBINARY and VARCHAR, BLOB and TEXT). The ...
https://dev.mysql.com/ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 13.7.6.1, “SET Syntax for Variable Assignment”). However, not all system variables can be ...
https://dev.mysql.com/null-values.html
For text file import or export operations performed with LOAD DATA or SELECT ... The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from values such as 0 for numeric types or the ...
https://dev.mysql.com/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. Rather than testing for equality against a very long text string, you can store a hash of the column value in a separate column, index that column, and test the ...Do ...
https://dev.mysql.com/optimize-table.html
After doing substantial insert, update, or delete operations on columns that are part of a FULLTEXT index in an InnoDB table. After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with ...
https://dev.mysql.com/optimizer-trace-table.html
The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each ...
