Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-analysis.html
tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. tmp_disk_tables The total number of internal on-disk temporary tables created by occurrences of the statement. The statement_analysis and ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. If you are interested only in accessing an existing database, you may want to skip the sections that describe ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. VALUES row_constructor_list [ORDER BY column_designator] [LIMIT ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
These functions permit the server's list of version tokens to be created, changed, removed, and inspected: version_tokens_set() completely replaces the current list and assigns a new list. Before using Version Tokens, install it according to the ...
https://dev.mysql.com/doc/refman/8.4/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue, a temporary table is created. This section discusses optimizations that can be ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
A series of backups, consisting typically of a full backup followed by a series of incremental backups, has been created for the server. You can restore your database server to its state at an arbitrary time using the binary log files included in ...