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/key-cache-restructuring.html
Instead, the server directly accesses the table indexes using native file system caching. After the cache has been restructured, it becomes available again for caching indexes assigned to it, and the use of file system caching for the indexes ceases. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's old structure and creates a new one based on the new ...
https://dev.mysql.com/doc/refman/8.0/en/mysql.html
You can execute SQL statements in a script file (batch file) like this: mysql db_name < script.sql > output.tab On Unix, the mysql client logs statements executed interactively to a history file. When used noninteractively (for example, as a ...
https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html
MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable authentication. Note The mysql_native_password ...
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. The table contains a row for ...The SENSITIVE_VARIABLES_OBSERVER privilege is required to view the values of sensitive system variables in this ...Variables are ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
In a failover situation, all the servers in the group are typically executing the same events from the same binary log file, so changing the source of the events should not affect the structure or integrity of the database, provided that you ...The ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement (prior to MySQL 8.0.23: CHANGE MASTER ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-methods.html
Distribution files have names of the form mysql-VERSION.tar.gz, mysql-VERSION.zip, or mysql-VERSION.rpm, where VERSION is a number like 8.0.44. File names for source distributions can be distinguished from those for precompiled binary distributions ... There are two methods for installing MySQL from source: Use a standard MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. file_ios The total number of file I/O events for the host. file_io_latency The total wait time of timed file I/O events for the host. The host_summary and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. file_ios The total number of file I/O events for the user. file_io_latency The total wait time of timed file I/O events for the user. The user_summary and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. Privileges are as for other databases and tables: ... The name of the performance_schema database is lowercase, as are the names of tables within ...Some of the setup tables have columns that can ...Truncation is permitted to clear ...