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/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. These rules ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. By default, MySQL Enterprise Audit uses tables in the mysql system database for persistent ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/automatic-start.html
The following table shows which option groups the server and startup scripts read from option files. Table 2.15 MySQL Startup Scripts and Supported Server Option Groups Script Option Groups mysqld [mysqld], [server], [mysqld-major_version] ... This ...
https://dev.mysql.com/doc/refman/8.0/en/changing-mysql-user.html
For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On Windows, you can run the server as a Windows service using a normal user account. On ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html
The signature file has the same name as the distribution file with an .asc extension, as shown by the examples in the following table. Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
Table 8.19 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). This section describes how to install and configure the clone plugin. For ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
The host cache, which is accessible using the Performance Schema host_cache table. See Section 7.1.12.3, “DNS Lookups and the Host Cache”, and Section 29.12.21.3, “The host_cache Table”. If connection problems occur such as communication ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-variables.html
For more detailed connection control monitoring information, examine the INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS table; see Section 28.6.2, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”. This ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html
In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data dictionaries. MySQL Server incorporates a transactional data dictionary that stores information about database ...