PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Be aware that, if your application uses REPLACE statements and you do this, the results of these statements can be drastically altered. See Section 13.2.8, “REPLACE Statement”, for more information and an example. This section discusses current ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The correct way to remove them is to replace them with TRUE, so that we do not miss any matching rows when doing the range scan. The range access method uses a single index to retrieve a subset of table rows that are contained within one or several ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Replace the password with the password that you want to use. Replace the password with the password that you want to use. Replace the password with the password that you want to use. If you have never assigned a root password for MySQL, the server ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
Search the bugs database at http://bugs.mysql.com/ to see whether the bug has been reported and fixed. If you cannot find an answer in the manual, the bugs database, or the mailing list archives, check with your local MySQL expert. The normal way to ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
The following list shows the CHANGE REPLICATION FILTER options and how they relate to --replicate-* server options: REPLICATE_DO_DB: Include updates based on database name. REPLICATE_REWRITE_DB: Perform updates on replica after substituting new name ...Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD first (and restarted with START SLAVE SQL_THREAD ...