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/keyring-component-plugin-comparison.html
The MySQL Keyring originally implemented keystore capabilities using server plugins, but began transitioning to use the component infrastructure in MySQL 8.0.24. A keyring component must be enabled on the MySQL server instance to support secure ...
https://dev.mysql.com/doc/refman/8.0/en/local-variable-scope.html
INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. MySQL interprets this as a reference to the variable of that name rather than a ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-upgrade-testing.html
When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production version. (This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data ...Then ...
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 ...