Search Results
https://dev.mysql.com/doc/refman/8.4/en/obtaining-component-information.html
The mysql.component system table contains information about currently loaded components and shows which components have been registered using INSTALL COMPONENT. For example: mysql> SELECT * FROM mysql.component; ...
https://dev.mysql.com/doc/refman/8.4/en/operator-precedence.html
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 comparison operator, it has the same precedence as <=>, >=, >, <=, <, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 8.4. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits Table”. Example data lock information: mysql> SELECT * FROM performance_schema.data_locks\G *************************** 1.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
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 Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ... 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
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...
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 ...