PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
It is very important to remember that, when you drop a partition, you also delete all the data that was stored in that partition. DROP PARTITION with ALGORITHM=INPLACE deletes data stored in the partition and drops the partition. However, as ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
In effect, different portions of a table are stored as separate tables in different locations. In the case of RANGE, LIST, and [LINEAR] HASH partitioning, the value of the partitioning column is passed to the partitioning function, which returns an ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
The MySQL system table mysql.gtid_executed is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. The value stored by the gtid_next system ... A ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
The special “zero” date '0000-00-00' can be stored and retrieved as '0000-00-00'. If you enable the ALLOW_INVALID_DATES SQL mode, MySQL permits you to store dates that are given only limited checking: MySQL requires only that the day is in the ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
persist_sensitive_variables_in_plaintext: Whether the server is permitted to store the values of sensitive system variables in an unencrypted format. temptable_max_ram: Defines maximum amount of memory that can occupied by TempTable storage engine ... Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
In addition, once an extent is allocated to a given partition, it cannot be used to store data from a different partition; an extent cannot store data from more than one partition. This means, for example that a tablespace having a single datafile ...The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM tables have the following characteristics: All data values are stored with the low byte first. All numeric key values are stored with the high byte first to permit better index compression. myisamchk --analyze stores statistics for portions ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
Whether it is used is up to the application.) The display width does not constrain the range of values that can be stored in the column. If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
Since 5 is not less than 5 and 12 is not less than 12, (5,12) is considered not less than (5,12), and is stored in partition p1. Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
To change the number of messages the server can store, change the value of max_error_count. max_error_count controls only how many messages are stored, not how many are counted. In this case, warning_count still indicates how many warnings occurred, ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...