PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-sql-mode.html
This advice applies whether you are using statement-based or row-based replication. Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. You should also avoid using any statement that accesses both transactional (or temporary) and nontransactional tables ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
| +-------------------------------------------------------------------------+ 1 row in set (0.00 sec) For more information, see Section 19.4.9, “Switching Sources and Replicas with Asynchronous Connection Failover”. The following functions, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
However, it should be safe to use --replicate-do-db for this purpose if you are using row-based replication only, since in this case the currently selected database has no effect on the option's operation. There may be situations where you have a ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
The last (stacked) diagnostics area, which has the condition areas that were set up before the handler took control. If @a is not 0, the handler simply ends, which means that there is no more use for the current diagnostics area (it has been ...
https://dev.mysql.com/doc/refman/8.0/en/retrieving-data.html
If it is present, conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for retrieval. The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
If any errors occur, the plugin sets the message column for the appropriate rule rows in the table and sets the Rewriter_reload_error status variable to ON. Users communicate with the plugin by modifying the set of rules stored in this table. The ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
The plugin communicates with users by setting the message column of table rows. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
It is possible for a row in the mysql.user system table to serve as both an account and a role. MySQL role names refer to roles, which are named collections of privileges. Role names have syntax and semantics similar to account names; see Section ...