PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-ndb-replication-applier-status-table.html
API_WAIT_EXEC_COMPLETE_COUNT: The number of times this thread has been blocked while waiting for an operation by this SQL node to complete. API_WAIT_SCAN_RESULT_COUNT: The number of times this thread has been blocked while waiting for a scan-based ... NDBCLUSTER exposes its internal replication applier state for observation using global status variables such as Ndb_replica_max_replicated_epoch and Ndb_api_trans_start_count_replica, but these values reflect the state of the default replication channel ...
https://dev.mysql.com/doc/refman/9.7/en/source-configuration-options.html
Many options configure compile-time defaults that can be overridden at server startup. OFF WITH_HYPERGRAPH_OPTIMIZER Whether hypergraph optimizer is compiled in and may be enabled at runtime ON WITH_ICU Type of ICU support bundled ... The CMake ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...