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/replication-options-source.html
For example, if rpl_semi_sync_master_wait_for_slave_count is 2, then 2 replicas must acknowledge receipt of the transaction before the timeout period configured by rpl_semi_sync_master_timeout for semisynchronous replication to proceed. If fewer ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: Waiting for source to send event Info: NULL *************************** 2. row *************************** Id: 2 User: system user Host: db: ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
By default, rows are sorted by descending process time and descending wait time. time The time in seconds that the thread has been in its current state. lock_latency The time spent waiting for locks by the current statement. last_wait_latency The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & The first time you start the MySQL 8.0 server (in an earlier step), you may notice messages in the error log regarding nonupgraded tables. If ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
MASTER_CONNECT_RETRY = interval Specifies the interval in seconds between the reconnection attempts that the replica makes after the connection to the source times out. MASTER_HEARTBEAT_PERIOD = interval Controls the heartbeat interval, which stops ...] CHANGE MASTER TO changes the parameters that the replica server uses for connecting to the source and for reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
To arrange for MySQL to start without manual intervention at system boot time, see Section 2.9.5, “Starting and Stopping MySQL Automatically”. Data directory initialization creates time zone tables in the mysql schema but does not populate them.
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. If a CTE is materialized by a query, it is materialized once for the query, even if the query references it several times. This is similar to automatic ...