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/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; ...The component_urn is the URN used ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-plugin-information.html
The mysql.plugin table shows which plugins have been registered with INSTALL PLUGIN. There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded plugin. Any that ...
https://dev.mysql.com/doc/refman/8.0/en/operator-precedence.html
Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 11.4, “User-Defined Variables”, explain how MySQL determines which interpretation of = should apply. For example: mysql> SELECT 1+2*3; -> 7 mysql> SELECT (1+2)*3; -> 9 .
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_accounts_size ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-status-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_status table has these columns: ID A unique cloning operation identifier in the current MySQL server instance. BEGIN_TIME A timestamp in 'YYYY-MM-DD ...The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. MySQL does not perform matching of Host column values in the mysql.user system table ...The host_cache_size system variable controls the size of the host cache, as well as the size of the host_cache ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table (available as of MySQL 8.0.24) provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-keys-table.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. As of MySQL 8.0.16, the keyring_keys table exposes metadata for keys in the keyring. Key metadata ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-tables.html
The following sections describe the Performance Schema tables associated with the MySQL keyring (see Section 8.4.4, “The MySQL Keyring”). They provide information about keyring operation: keyring_component_status: Information about the keyring ...