PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
If the GTID has already been used, no error is raised, and the auto-skip function is used to ignore the transaction. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
In any of the cases just mentioned, the one-to-one correspondence between transactions and GTIDs is broken, with the result that GTID-based replication cannot function correctly. CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, copying the data directory cannot be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-table-options.html
If so, and the statement occurs within a stored function, the replica executes the statement and exits. If row-based replication is enabled, the replica does not know whether a statement occurred within a stored function on the source, so this ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
A new savepoint level is created when a stored function is invoked or a trigger is activated. When the function or trigger terminates, any savepoints it created are released and the previous savepoint level is restored. SAVEPOINT identifier ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If the older ext/mysql extension must be used, then for escaping use the mysql_real_escape_string_quote() function and not mysql_escape_string() or addslashes() because only mysql_real_escape_string_quote() is character set-aware; the other ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
Instead, use SHA2() or some other one-way hashing function and store the hash value. To prevent password recovery using rainbow tables, do not use these functions on a plain password; instead, choose some string to be used as a salt, and use ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Data Masking and De-Identification, implemented as a plugin library containing a plugin and a set of functions. MySQL Enterprise Data Masking and De-Identification functions enable masking existing ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Isolate and tune any part of the query, such as a function call, that takes excessive time. Depending on how the query is structured, a function could be called once for every row in the result set, or even once for every row in the table, greatly ... Queries, in the form of SELECT statements, perform all the lookup operations in the ...