PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/kill.html
KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. You can also use the mysqladmin processlist and mysqladmin kill commands to examine and kill threads. In most cases, it might take some time for the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html
Or wait for a day, or whatever time period you consider safe for your deployment. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
For the ins_sum trigger defined in Section 27.3, “Using Triggers”, the output of SHOW TRIGGERS is as shown here: mysql> SHOW TRIGGERS LIKE 'acc%'\G *************************** 1. This is a TIMESTAMP(2) value (with a fractional part in hundredths ... SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
The effects of the statement are not persistent; any filters set using CHANGE REPLICATION FILTER are lost following a restart of the replica mysqld. Note Global replication filters cannot be set on a MySQL server instance that is configured for ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE information_schema_stats_expiry can be set to 0 to have ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
Group Replication uses a combination of these methods for state transfer during distributed recovery: A remote cloning operation using the clone plugin's function, which is available beginning with MySQL 8.0.17. As state transfer from the binary log ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmpmem-table.html
RELOCATION_OPS The number of times a block of size PAGE_SIZE has been relocated. RELOCATION_TIME The total time in microseconds used for relocating blocks of size PAGE_SIZE. row *************************** page_size: 1024 buffer_pool_instance: 0 ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...