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-schema-auto-increment-columns.html
Tables in these schemas are excluded from view output: mysql, sys, INFORMATION_SCHEMA, performance_schema. This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
The complete trace is shown here: mysql> SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: ...
https://dev.mysql.com/doc/refman/8.0/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
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/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized ...