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-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
Note This does not work with InnoDB databases unless you use innodb_file_per_table. There may be situations where you have a single source server and want to replicate different databases to different replicas. For example, you may want to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-performance.html
Note that a buffer the size of this value is allocated for each thread that reads from the binary log and relay log files, including dump threads on sources and coordinator threads on replicas. As the number of replicas connecting to a source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads.html
Note Multithreaded replicas are supported by NDB Cluster beginning with NDB 8.0.33. MySQL replication capabilities are implemented using the following types of threads: Binary log dump thread. The source creates a thread to send the binary log ...
https://dev.mysql.com/doc/refman/8.0/en/restart.html
Note After executing a RESTART statement, the client can expect the current connection to be lost. One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
Table 8.15 System and Status Variables for Session Reuse System Variable Name Corresponding Status Variable Name ssl_session_cache_mode Ssl_session_cache_mode ssl_session_cache_timeout Ssl_session_cache_timeout Note When the value of the ... As of ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-installation.html
Note If installed, the Rewriter plugin involves some overhead even when disabled. To avoid this overhead, do not install the plugin unless you plan to use it. To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
row *************************** Level: Note Code: 1105 Message: Query 'SELECT 10' rewritten to 'SELECT 10 + 1' by a query rewrite plugin A statement need not be rewritten to a statement of the same type. To enable or disable the plugin, enable or ...