PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-max-allowed-packet.html
max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including replicas. If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. The user name is specified by the SOURCE_USER option of the CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/9.7/en/replication-snapshot-method.html
If the source database contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source database. To select the appropriate method of dumping the database, choose between these ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-diffengines.html
It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine types. This provides a number of benefits in the replication process in that you can take ...
https://dev.mysql.com/doc/refman/9.7/en/semijoins-antijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...
https://dev.mysql.com/doc/refman/9.7/en/setting-environment-variables.html
Environment variables can be set at the command prompt to affect the current invocation of your command processor, or set permanently to affect future invocations. To set a variable permanently, you can set it in a startup file or by using the ...
https://dev.mysql.com/doc/refman/9.7/en/show-binlog-events.html
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not specify 'log_name', the first binary log is displayed. The LIMIT clause has the same syntax as for the SELECT statement.
https://dev.mysql.com/doc/refman/9.7/en/show-create-library.html
SHOW CREATE LIBRARY [database_name.]library_name Returns the text that can be used to re-create the named JavaScript or WebAssembly library in the named database; the database defaults to the current database if one is not specified. For an account ...
https://dev.mysql.com/doc/refman/9.7/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...