PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
MySQL on Windows Considerations Large Table Support If you need tables with a size larger than 4GB, install MySQL on an NTFS or newer file system. For example: Developer Default: Provides a setup type that includes the selected version of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. When the PARTITION option is used, only the partitions and subpartitions listed are checked for matching rows. This option can be used in a ...Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key respects: The partitions to be checked are specified by the issuer of the statement, unlike partition pruning, which is ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
A single-row subquery from a table or tables is not considered a constant. Comparisons between floating-point numbers and large integer values are approximate because the integer is converted to double-precision floating point before comparison, ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
INTERSECT: Combine only those rows which the results of two query blocks have in common, omitting any duplicates. In other words, all of the following statements are true: TABLE x UNION TABLE y and TABLE y UNION TABLE x produce the same result, ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
For a nontransactional table, abort the statement if the value occurs in a single-row statement or the first row of a multiple-row statement. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. There are several types of insertions that are used: An INSERT statement just pushes rows into a compression buffer, ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
One circumstance under which this occurs is when the optimizer estimates that using the index would require MySQL to access a very large percentage of the rows in the table. For example, the following SELECT statements use indexes: SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Dropping and re-adding an index can be expensive for a large table, whereas making it invisible and visible are fast, in-place operations. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted rows are maintained in a linked list and ...