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-table-exists.html
When the procedure returns, the variable has one of the following values to indicate whether the table exists: '': The table name does not exist as a base table, TEMPORARY table, or view. Tests whether a given table exists as a regular table, a ...
https://dev.mysql.com/doc/refman/8.0/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-reset-to-default.html
Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure execution. row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/sys-ps-statement-avg-latency-histogram.html
This procedure can be used to display a very high-level picture of the latency distribution of statements running within this MySQL instance. Displays a textual histogram graph of the average latency values across all normalized statements tracked ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
(See Section 2.3.3, “MySQL Installer for Windows”.) Otherwise, use the password-assignment procedure given in Section 2.9.4, “Securing the Initial MySQL Account”. GUI tools exist that perform most of the tasks described in this section, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-background-threads.html
Produces a result set indicating how many background threads were disabled. Example mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-consumer.html
Disables Performance Schema consumers with names that contain the argument. Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern match. Example Disable ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-instrument.html
Disables Performance Schema instruments with names that contain the argument. Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Example ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Example Disable a ...