PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. See ...In addition (as with RANGE COLUMNS partitioning), you can use multiple columns in the COLUMNS() ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL 5.7. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, ...Rebuilds the partition; this has the same effect as dropping all records stored in the partition, then reinserting ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
There are also ways to obtain information about partitioned tables and partitions. For information about partition management in tables partitioned by RANGE or LIST, see Section 22.3.1, “Management of RANGE and LIST Partitions”. For a discussion ... MySQL 5.7 provides a number of ways to modify partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.html
For example, if you are using a chained or circular replication setup, you cannot use MySQL 5.7.22, MySQL 5.7.23, and MySQL 5.7.24 concurrently, although you could use any two of these releases together. For example, you can replicate from a source ... MySQL supports replication from one release series to the next higher release ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transactions.html
The server uses these rules for binary logging: If the initial statements in a transaction are nontransactional, they are written to the binary log immediately. Otherwise, they are discarded.) For statement-based logging, logging of nontransactional ...In general, you should avoid transactions that update both transactional and nontransactional tables in a replication ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. For information about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-wait-by-bytes.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. avg_read The average number of bytes per read for the I/O event. avg_written The average number of bytes per write for the I/O event. By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-global-by-current-bytes.html
current_alloc The current number of allocated bytes that have not been freed yet for the event. current_avg_alloc The current number of allocated bytes per memory block for the event. high_count The high-water mark for number of memory blocks ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-syslog.html
(On Windows, log_syslog is enabled by default.) If log_syslog is enabled, the following system variables can also be used for finer control. Note Using mysqld_safe for syslog error logging is deprecated; you should use the server system variables ...