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/replication-asynchronous-connection-failover-replica.html
When the feature is active and correctly configured, if the primary that is replicating goes offline or into an error state, the new primary starts replication on the same channel when it is elected. To configure this feature, the replication ... In ...Ensure that SOURCE_RETRY_COUNT and SOURCE_CONNECT_RETRY are set to minimal numbers that just allow a few retry attempts, for example 3 and ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
When the sort buffer becomes full, entries are sorted and written out to a temporary intermediate file. In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the file. This ...
https://dev.mysql.com/doc/refman/8.0/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy process. It also provides relevant information for individual storage engines, ...When the log_status table is queried, the server blocks logging and related administrative changes for just long enough to populate the table, then releases the ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines. Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent).
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 ...