PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/5.7/en/null-values.html
Treatment of \N as a synonym for NULL in SQL statements is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0; use NULL instead. Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string ... The NULL value means “no data.” NULL can be written in any ...
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 ...