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/sys-statements-with-full-table-scans.html
By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. total_latency The total wait time of timed statement events for the statement. no_index_used_count The total number of times no index was ... These views display normalized statements that have done full table ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have these columns: query The normalized statement string. total_latency The ...db The default database for the statement, or NULL if there is ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-components.html
From MySQL 8.0.30, log_error_services also implicitly loads error log components if they are not already loaded. Whether the component can be listed multiple times in the log_error_services value. If log_sink_json is named multiple times in the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html
COMPRESS_TIME The total time in seconds used for compressing data in this index. Compressed InnoDB pages are uncompressed whenever compression fails, or the first time a compressed page is accessed in the buffer pool and the uncompressed page does ... The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you evaluate the performance and usefulness of compression for specific ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
UPDATE_TIME The time that the partition or subpartition was last modified. CHECK_TIME The last time that the table to which this partition or subpartition belongs was checked. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-midpoint_insertion.html
Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL option file (my.cnf or my.ini) or changed at runtime with the SET GLOBAL statement. The pages are moved to the front of the list (the most-recently used end) when ...
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 *************************** ...