PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior of such tables, and could easily lead to corruption or loss of data. In some cases, using large numbers (hundreds) of ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/9.7/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-literals.html
Previously, MySQL supported arbitrary numbers of leading and trailing whitespace characters in date and time values, as well as between the date and time parts of DATETIME and TIMESTAMP values. Numbers that are not one of these lengths are ...
https://dev.mysql.com/doc/refman/9.7/en/error-message-elements.html
When an error in this range originates on the server side, the server writes it to the error log, padding the error code with leading zeros to six digits and adding a prefix of MY-. When an error in this range occurs, the server writes it to the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html
Otherwise, statistics may be recalculated frequently which can lead to variations in query execution plans. Warning Starting the server with tablespace path validation disabled after moving tablespace files can lead to undefined behavior. InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
Consequently, different estimates could be produced when recalculating statistics leading to different choices in query execution plans and variation in query performance. Decreasing the value too much, however, could lead to the first problem of ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-api-statistics.html
In order to minimize confusion with standard MySQL session variables, we refer to the variables that correspond to these NDB API session counters as “_session variables”, with a leading underscore. We refer to the related status variables as ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/9.7/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
For CHAR, VARCHAR, BINARY, and VARBINARY columns, indexes can be created that use only the leading part of column values, using col_name(length) syntax to specify an index prefix length. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] ...