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/faqs-cjk.html
Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) column. row *************************** Level: Warning Code: 1366 Message: Incorrect string value: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html
--defaults-extra-file Command-Line Format --defaults-extra-file=path Type String Default Value [none] Read given file after global files are read. --defaults-file Command-Line Format --defaults-file=path Type String Default Value [none] Read default ... ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
--debug[=debug_options], -# [debug_options] Command-Line Format --debug[=#] Type String Default Value d:t:O,/tmp/mysql_upgrade.trace Write a debugging log. --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint about ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
--debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] Type String Default Value d:t:o Write a debugging log. --default-character-set=charset_name Command-Line Format --default-character-set=charset_name Type String ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
As of MySQL 5.7.13, if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based filtering. The value for either variable can be NULL or a string containing one or more comma-separated account names, ... Note This section describes legacy audit log filtering, which applies under either of these circumstances: Before MySQL 5.7.13, that is, prior to the introduction of rule-based audit log filtering described in Section 6.4.5.7, “Audit Log ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In this case, the statement displays output only for the columns with names matching the string. There is no need to enclose the string within quotation marks unless it contains spaces or other special characters. You should be aware that while this ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
InnoDB can handle composing and decomposing multiple column values into a single memcached item value, reducing the amount of string parsing and concatenation required in your application. For example, you can store the string value 2|4|6|8 in the ...The combination of InnoDB tables and memcached offers advantages over using either by ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
For column values calculated as a result of string expressions (such as those that invoke a string-valued function), the filesort algorithm cannot tell the maximum length of expression values, so it must allocate max_sort_length bytes for each tuple. For example, if tuples store values of long string columns and you increase the value of max_sort_length, the size of sort buffer tuples increases as well and may require you to increase ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/year.html
YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. As 1- or 2-digit strings in the range '0' to '99'. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. As the ...