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-features-functions.html
The GET_LOCK(), RELEASE_LOCK(), IS_FREE_LOCK(), and IS_USED_LOCK() functions that handle user-level locks are replicated without the replica knowing the concurrency context on the source. INTO, and then store the variable in the table, like this: ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O thread. max_allowed_packet ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replication metadata repositories (see Section 16.2.4.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... 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/select-into.html
Example: SELECT * FROM t1 INTO @myvar FOR UPDATE; An INTO clause should not be used in a nested SELECT because such a SELECT must return its result to the outer context. INTO OUTFILE statement is intended to enable dumping a table to a text file on ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
For extended EXPLAIN output, the text displayed by a following SHOW WARNINGS shows the rewritten query, which displays the semijoin structure. A semijoin is a preparation-time transformation that enables multiple execution strategies such as table ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
If your shell is tcsh, add the following line to your .tcshrc file: setenv PATH ${PATH}:/usr/local/mysql/bin If the appropriate startup file does not exist in your home directory, create it with a text editor. Environment variables can be set at ...
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
As an alternative to SHOW BINLOG EVENTS, use the mysqlbinlog utility to save the binary log to a text file for later examination and analysis. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
Passwords in statements written to the slow query log are rewritten by the server not to occur literally in plain text. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least ...