PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
You can set the value of gtid_purged in order to record on the server that the transactions in a certain GTID set have been applied, although they do not exist in any binary log on the server. The MySQL Server system variables described in this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
With row-based format, DML statements are handled based on the database where the modified table exists. However, the result of the DML INSERT statement is different depending on the binary logging format: If row-based binary logging format is in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-rawdata.html
This requires that the binary logs still exist on the source server. If your replica is replicating LOAD DATA statements, you should also back up any SQL_LOAD-* files that exist in the directory that the replica uses for this purpose. To guarantee ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
If a specific engine does not exist for a table to be created, MySQL uses the default engine type, usually MyISAM. If you are already running a replication solution and want to convert your existing tables to another engine type, follow these steps: ... It does not matter for the replication process whether the source table on the source and the replicated table on the replica use different engine ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. When replication is running ... RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
For details on the levels at which privileges exist, the permissible priv_type, priv_level, and object_type values, and the syntax for specifying users and passwords, see Section 13.7.1.4, “GRANT Statement”. User accounts from which privileges ...The REVOKE statement enables system administrators to revoke privileges from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
If the column exists when the rules table is loaded into memory, the plugin updates it with the pattern digest. If the column exists when the rules table is loaded into memory, the plugin updates it with the normalized form of the pattern. Users ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Prior to SQL-92, outer joins did not exist, so subqueries were the only way to do certain things. Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. When you start the mysqld server, you can specify program options using any of the methods described ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...