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/version-tokens-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). To avoid this overhead, do not install it unless you plan to use it. This section describes ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens.html
MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. The Version Tokens interface has these characteristics: Version ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions.html
MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row. The following sections discuss how to use window functions, including descriptions of the OVER and WINDOW clauses. For ...
https://dev.mysql.com/doc/refman/8.0/en/windows-initialize-data-directory.html
If you installed MySQL using the noinstall package, no data directory is included. To initialize the data directory, use the instructions at Section 2.9.1, “Initializing the Data Directory”.
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/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 ...