PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. One of these is to modify the table definition before importing it into the Cluster database. The easiest way to accomplish this is to do a ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
NDB 7.6 adds two tables to the ndbinfo information database to provide information about cluster nodes; these tables are listed here: config_nodes: This table the node ID, process type, and host name for each node listed in an NDB cluster's ... New ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
In this example, an innodb checksum is rewritten to replace an invalid checksum: innochecksum --no-check --write innodb ../data/test/tab1.ibd --allow-mismatches, -a Command-Line Format --allow-mismatches=# Type Integer Default Value 0 Minimum Value ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
FROM is a consistent read, reading a snapshot of the database and setting no locks unless the transaction isolation level is set to SERIALIZABLE. REPLACE is done like an INSERT if there is no collision on a unique key. Otherwise, an exclusive ... A ...
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 ...