https://dev.mysql.com/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...
https://dev.mysql.com/partitioning-limitations.html
Columns with spatial data types such as POINT or GEOMETRY cannot be used in partitioned tables. This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning ...
https://dev.mysql.com/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/partitioning-range.html
At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE statement to add new partitions for stores 21-25, 26-30, and so on (see Section 23.3, “Partition Management”, for details of ...
https://dev.mysql.com/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/performance-schema-atom-molecule-events.html
At this point, and until the next subsidiary event begins, the table I/O wait is also the most recent wait of any kind. For a table I/O event, there are usually two rows in events_waits_current, not one. For example, a row fetch might result in ...
https://dev.mysql.com/plugin-loading.html
However, removing options for a plugin from the my.cnf file may not be sufficient to uninstall it if at some point INSTALL PLUGIN has also been used. Server plugins must be loaded into the server before they can be used. It is also possible to ...
https://dev.mysql.com/prepared-statements-instances-table.html
For a prepared statement created by a stored program, these columns point to the stored program. The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed ...
https://dev.mysql.com/privilege-changes.html
The in-memory tables become effective for access control at that point. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant ...
https://dev.mysql.com/problems-with-null.html
If you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that ...
