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-table-statistics.html
update_latency The total wait time of timed update I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-and-plugins.html
Time spent executing the code while the plugin was loaded was still spent even if the plugin is unloaded later. For additional information about the effect of plugin installation and removal, see Section 29.7, “Performance Schema Status ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Memory instruments have names in the form of memory/code_area/instrument_name, where code_area is a value such as sql or innodb, and ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
That enables you to avoid typing them each time you run the program while enabling you to override the defaults if necessary by using command-line options. There are several ways to specify options for MySQL programs: List the options on the ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
To update cached values at any time for a given table, use ANALYZE TABLE information_schema_stats_expiry can be set to 0 to have INFORMATION_SCHEMA queries retrieve the latest statistics directly from the storage engine, which is not as fast as ...
https://dev.mysql.com/doc/refman/8.0/en/conditions-and-parameters.html
If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller. If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements-and-limitations.html
This section lists and explains the requirements and limitations of Group Replication.
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. The LIKE clause, if present, indicates which table names (not trigger names) to match and causes the statement to display triggers for those ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...rows_sent The total number of rows returned by statements for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...