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/sys-ps-setup-show-enabled-consumers.html
Example mysql> CALL sys.ps_setup_show_enabled_consumers(); +-----------------------------+ | enabled_consumers | +-----------------------------+ | events_statements_current | | events_statements_history | | events_transactions_current | | ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-account.html
Example mysql> SELECT sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())); +----------------------------------------------------------+ | sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())) | ... Given a Performance Schema thread ID, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html
+-----------------------------------------------------------------+ | sql_text | +-----------------------------------------------------------------+ | select hibeventhe0_.id as id1382_, hibeventhe0_.createdTime ... Traces all Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-truncate-all-tables.html
Example mysql> CALL sys.ps_truncate_all_tables(FALSE); +---------------------+ | summary | +---------------------+ | Truncated 49 tables | +---------------------+ . Truncates all Performance Schema summary tables, resetting all aggregated ...
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 ...