PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html
All of these columns are taken into account both for the purpose of placing rows in partitions and for the determination of which partitions are to be checked for matching rows in partition pruning. In addition, both RANGE COLUMNS partitioning and ... The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-handling-nulls.html
For example, both VALUES IN (NULL) and VALUES IN (1, 4, 7, NULL) are valid, as are VALUES IN (1, NULL, 4, 7), VALUES IN (NULL, 1, 4, 7), and so on. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-prepared-statements-instances-table.html
SQL Statement Corresponding Server Command PREPARE SQLCOM_PREPARE EXECUTE SQLCOM_EXECUTE DEALLOCATE PREPARE, DROP PREPARE SQLCOM_DEALLOCATE PREPARE Performance Schema prepared statement instrumentation covers both protocols. The Performance Schema ...
https://dev.mysql.com/doc/refman/9.7/en/perl-support-problems.html
Another cause of this problem may be that Perl and MySQL are not both compiled with gcc. In this case, you can solve the mismatch by compiling both with gcc. If Perl reports that it cannot find the ../mysql/mysql.so module, the problem is probably ...
https://dev.mysql.com/doc/refman/9.7/en/plugin-loading.html
Plugins normally are installed using either a plugin-loading option at startup or with INSTALL PLUGIN at runtime, but not both. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-numbers.html
Exact-value numeric literals have an integer part or fractional part, or both. The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals.
https://dev.mysql.com/doc/refman/9.7/en/proxy-users.html
By proxied_user for itself: The value of USER() must exactly match CURRENT_USER() and proxied_user, for both the user name and host name parts of the account name. Both accounts have the same user part (''), which matches any user. The plugin that ...
https://dev.mysql.com/doc/refman/9.7/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. The connection procedure negotiates the use of the highest TLS ...If ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-errors.html
If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. This includes the case that a statement produces an error on the source or the replica, but not both.