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/performance-schema-replication-applier-status-table.html
Thread-specific status information is available in the replication_applier_status_by_coordinator table (and replication_applier_status_by_worker if the replica is multithreaded). There is always a default replication channel, and more replication ...
https://dev.mysql.com/doc/refman/8.0/en/programs-development.html
In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given program. This works well for programs that use the last instance of an option that is specified multiple times. If you ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”. The MySQL server has many operating parameters, which you can change at server ...Note On Windows, the .ini or .cnf option file extension might not be ...
https://dev.mysql.com/doc/refman/8.0/en/show-binlog-events.html
Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server ...
https://dev.mysql.com/doc/refman/8.0/en/show-relaylog-events.html
Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the relay log (including all statements modifying data that have been ...If no channel is named and no extra channels exist, the statement applies to the default ... SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. It may occur for temporary tables created outside stored functions ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Returns a JSON object containing information about a ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
From MySQL 8.0.16, when insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. For an update event, the partition ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
There is no need for server failover, and the multi-source update everywhere nature ensures that even updates are not blocked in the event of a single server failure. There is a distributed recovery procedure to ensure that when servers join the ...