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/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
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/x-plugin-checking-installation.html
X Plugin is enabled by default in MySQL 8, therefore installing or upgrading to MySQL 8 makes the plugin available. You can verify X Plugin is installed on an instance of MySQL server by using the SHOW plugins statement to view the plugins list. | ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as RMs, and the server itself acts as a TM. The requirement that the ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
As of MySQL 8.0.14, the timestamp indicates when the slow statement began executing. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...By ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
The DEFINER clause specifies the MySQL account to be used when checking access privileges at trigger activation time. MySQL takes the DEFINER user into account when checking trigger privileges as follows: At CREATE TRIGGER time, the user who issues ... CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } other_trigger_name This statement creates a new ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. With the removal of .frm files in MySQL 8.0, this column ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
You can also get this list using the mysqlshow --status db_name command. With the removal of .frm files in MySQL 8.0, this column now reports a hardcoded value of 10, which is the last .frm file version used in MySQL 5.7. For example, InnoDB stores ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...