PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
Alternatively, you can issue SHOW RELAYLOG EVENTS on the replica or SHOW BINLOG EVENTS on the source. To see what the transaction is, issue SHOW RELAYLOG EVENTS on the replica or SHOW BINLOG EVENTS on the source, and search the output for a ... If ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-monitoring.html
To check their values, use SHOW VARIABLES: mysql> SHOW VARIABLES LIKE 'rpl_semi_sync%'; The status variables enable you to monitor the operation of semisynchronous replication. To check their values, use SHOW STATUS: mysql> SHOW STATUS LIKE ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-statements-replica.html
In addition to the statements described here, SHOW SLAVE STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For information about these statements, see Section 13.7.5.34, “SHOW SLAVE STATUS Statement”, and Section 13.7.5.32, “SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. Use the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
To examine sys schema object definitions, use the appropriate SHOW statement or INFORMATION_SCHEMA query. For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW ...Most ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
Viewing InnoDB Table Properties To view the properties of an InnoDB table, issue a SHOW TABLE STATUS statement: mysql> SHOW TABLE STATUS FROM test LIKE 't%' \G; *************************** 1. row *************************** Name: t1 Engine: InnoDB ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
To see what privileges a given account has, use the SHOW GRANTS statement. For example: SHOW GRANTS FOR 'joe'@'office.example.com'; SHOW GRANTS FOR 'joe'@'home.example.com'; Internally, the server stores privilege information in the grant tables of ... MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
To upgrade a KEY partitioned table that was created in MySQL 5.1, first execute SHOW CREATE TABLE and note the exact columns and number of partitions shown. (You should also include the LINEAR keyword if it was used for the original table ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
You can check whether the ARCHIVE storage engine is available with the SHOW ENGINES statement. The number of rows in ARCHIVE tables reported by SHOW TABLE STATUS is always accurate. See Section 13.7.2.4, “OPTIMIZE TABLE Statement”, Section ...