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/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
For example, for the following SQL statement, the name of the prepared statement is stmt: PREPARE stmt FROM 'SELECT 1'; SQL_TEXT The prepared statement text, with ? placeholder markers. These columns can be used to find stored programs that leak ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. If needed, these values can be obtained from the process list ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-actors-table.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination). The setup_actors table contains information that determines whether to enable monitoring and historical event ...