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/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/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/thread-pool-operation.html
thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority queue. Consider increasing the value if you experience slower response times due to long-running ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html
(For details about the permitted units specifiers, see the description of the DATE_ADD() function in Section 14.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/doc/refman/8.0/en/alter-user.html
role [, role ] ...: Set the default to the named roles, which must exist and be granted to the account at the time ALTER USER ... Order of WITH options does not matter, except that if a given resource limit is specified multiple times, the last ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
These roles must exist at the time CREATE USER is executed; otherwise the statement raises an error (ER_USER_DOES_NOT_EXIST), and the user is not created. Order of WITH options does not matter, except that if a given resource limit is specified ...
https://dev.mysql.com/doc/refman/8.0/en/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? ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.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. Even with file-per-table mode with each InnoDB table in a ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
config_options Table The config_options table stores memcached-related settings that can be changed at runtime using SQL. The expire_time_column value is related to the way memcached hashes requests to different servers and caches data in memory.