PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
statement_truncate_len, @sys.statement_truncate_len The maximum length of statements returned by the format_statement() function. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html
To prevent other simultaneous calls to save the configuration, ps_setup_save() acquires an advisory lock named sys.ps_setup_save by calling the GET_LOCK() function. This enables you to alter the configuration temporarily for debugging or other ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-overview.html
object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, PROCEDURE, TRIGGER, VIEW. This view summarizes the types of objects within each schema. Note For MySQL instances with a large number of objects, this view might take a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-reference.html
The sys schema includes tables and triggers, views, and stored procedures and functions.
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
Stored functions that query Performance Schema configuration and provide formatting services. MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. sys schema objects ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version.html
For example, use the VERSION() function to retrieve the MySQL server version. This view provides the current sys schema and MySQL server versions. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version.
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Disabling external locking does not affect MySQL's functionality as long as you run only one server. Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Some operating systems ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...
https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html
The server executes the plugin's deinitialization function and removes the row for the plugin from the mysql.plugin system table, so that subsequent server restarts do not load and initialize the plugin. UNINSTALL PLUGIN plugin_name This statement ...