https://dev.mysql.com/replication-options-gtids.html
--gtid-executed-compression-period Property Value Command-Line Format --gtid-executed-compression-period=# Type Integer Default Value 1000 Minimum Value 0 Maximum Value 4294967295 Compress the mysql.gtid_executed table each time this many ...
https://dev.mysql.com/sys-io-by-thread-by-latency.html
These views summarize I/O consumers to display time waiting for I/O, grouped by thread. total_latency The total wait time of timed I/O events for the thread. min_latency The minimum single wait time of timed I/O events for the thread. avg_latency ...The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the ...
https://dev.mysql.com/sys-io-global-by-file-by-latency.html
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. total_latency The total wait time of timed I/O events for the file. read_latency The total wait time of timed read I/O events for the file. write_latency ...The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns: file The file path ...
https://dev.mysql.com/sys-io-global-by-wait-by-bytes.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences of the I/O event. min_latency The minimum single wait time of timed occurrences ...By default, rows are sorted by descending total I/O (bytes read and ...
https://dev.mysql.com/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/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/upgrading-what-is-upgraded.html
One way that FORCE differs from AUTO is that with FORCE, the server re-creates system tables such as help tables or time zone tables if they are missing. Check and repair operations can be time-consuming, particularly for large tables. This ensures ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 5.3, “The mysql System ...
https://dev.mysql.com/window-functions-frames.html
(For details about the permitted units specifiers, see the description of the DATE_ADD() function in Section 12.7, “Date and Time Functions”.) RANGE on a numeric or temporal expr requires ORDER BY on a numeric or temporal expression, ... The ...
https://dev.mysql.com/added-deprecated-removed.html
This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.0. binlog_transaction_dependency_tracking: Source of dependency information (commit ...
https://dev.mysql.com/faqs-stored-procs.html
Do the preceding limitations affect the ability of MySQL to do point-in-time recovery? A.4.28. If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: ...Where can I find documentation for MySQL stored procedures and stored functions? ...
