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/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
Create the database first; its name should not exceed 64 characters. For example: mysql> CREATE DATABASE IF NOT EXISTS database-name; Next, run the script using the alternative database name. $> mysql -u root -p -D database-name < ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Tables created with these row formats enable you to index a maximum of 1024 or 768 characters for utf8mb3 or utf8mb4 columns, respectively. In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, ...
https://dev.mysql.com/doc/refman/8.0/en/except.html
As with UNION and INTERSECT, either query block can make use of any of SELECT, TABLE, or VALUES. query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
Along with the JSON data type, a set of SQL functions is available to enable operations on JSON values, such as creation, manipulation, and searching. JSON columns, like columns of other binary types, are not indexed directly; instead, you can ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
If the clone plugin is loaded but disabled, the tables are not created. Note The Performance Schema tables described here are available as of MySQL 8.0.17. The following sections describe the Performance Schema tables associated with the clone ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event ...Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
The audit_log plugin operates in legacy mode if it is installed but the accompanying audit tables and functions are not created. Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and ...