PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
More specifically, this means that the following two statements are true: No definition of an InnoDB table employing user-defined partitioning may contain foreign key references; no InnoDB table whose definition contains foreign key references may ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. The optimization known as partition pruning is ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
(See Bug #42849.) Range partitioning is particularly useful when one or more of the following conditions is true: You want or need to delete “old” data. A table that is partitioned by range is partitioned in such a way that each partition ...
https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-filtering.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 29.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the ...