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/mysql-cluster-options-variables.html
--ndb-transid-mysql-connection-map=state Command-Line Format --ndb-transid-mysql-connection-map[=state] Type Enumeration Default Value ON Valid Values ONOFFFORCE Enables or disables the plugin that handles the ndb_transid_mysql_connection_map table ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
Example 16.2 Backup and restore scenario The stored functions GTID_IS_EQUAL(), GTID_IS_DISJOINT(), and GTID_IS_DISJOINT_UNION() can be used to verify backup and restore operations involving multiple databases and servers. In this example scenario, ... This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
replicate-do-db: Tells replication SQL thread to restrict replication to specified database. replicate-ignore-db: Tells replication SQL thread not to replicate to specified database. slave_parallel_type: Tells replica to use timestamp information ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Sometimes people think that if a database contains only publicly available data, it need not be ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Stored routines can be particularly useful in certain situations: When multiple client applications are written in different languages or work on different platforms, but need to perform the same database operations. In such a setup, applications ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
For supplementary characters in general collations, the weight is the weight for 0xfffd REPLACEMENT CHARACTER. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
Because the MERGE engine cannot enforce uniqueness over the set of underlying tables, REPLACE does not work as expected. The two key facts are: REPLACE can detect unique key violations only in the underlying table to which it is going to write ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
REPLACE and INSERT lock only those partitions having rows to be inserted or replaced. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only ...