Search Results
https://dev.mysql.com/doc/refman/8.4/en/obtaining-component-information.html
For example: mysql> SELECT * FROM mysql.component; +--------------+--------------------+------------------------------------+ | component_id | component_group_id | component_urn | ... The mysql.component system table contains information about ...
https://dev.mysql.com/doc/refman/8.4/en/operator-precedence.html
For example: mysql> SELECT 1+2*3; -> 7 mysql> SELECT (1+2)*3; -> 9 . Operator precedences are shown in the following list, from highest precedence to the lowest. Operators that are shown together on a line have the same precedence. When used as a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
Similar to partitioning by RANGE, except that the partition is selected based on columns matching one of a set of discrete values. With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Operations performed by a restricted client result in an error until the user establishes a new account password: mysql> SELECT 1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
Example data lock information: mysql> SELECT * FROM performance_schema.data_locks\G *************************** 1. If there is no primary key, LOCK_DATA shows either the key values of a selected unique index or the unique InnoDB internal row ID ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Granting the SELECT privilege for the error_log table thus gives clients and applications access to error log contents using SQL queries, enabling DBAs to provide access to the log without the need to permit direct file system access on the server ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
For example, the statement/sql/create_db and statement/sql/select instruments are used for CREATE DATABASE and SELECT statements. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. Variables are persisted using ...