PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
The following statements are equivalent: SELECT EVENT_SCHEMA, EVENT_NAME, DEFINER, TIME_ZONE, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STARTS, ENDS, STATUS, ORIGINATOR, CHARACTER_SET_CLIENT, COLLATION_CONNECTION, DATABASE_COLLATION ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Selecting columns or using retrieval conditions for dynamic metadata along with static metadata adds overhead to process the dynamic metadata. Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Session 3: mysql> SELECT * FROM t1; The SELECT statement issued in ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
The directory selected for the redo log archive file must exist when redo log archiving is activated, or an error is returned. The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API ...
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_kerberos'; +-------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... Note Kerberos pluggable ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%ldap%'; +----------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
For example, suppose that you execute these statements: SELECT GET_LOCK('lock1',10); SELECT GET_LOCK('lock2',10); SELECT RELEASE_LOCK('lock2'); SELECT RELEASE_LOCK('lock1'); The second GET_LOCK() acquires a second lock and both RELEASE_LOCK() calls ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-nodes.html
This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. For nodes that are starting, it also shows the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--bind-address=ip_address Command-Line Format --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. --database=db_name, -d db_name ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
mysql> SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | PS_CURRENT_THREAD_ID() | +------------------------+ | 52 | +------------------------+ mysql> SELECT PS_THREAD_ID(CONNECTION_ID()); +-------------------------------+ | ... As of MySQL ...