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
There are two exceptions to this restriction: When partitioning by [LINEAR] KEY, it is possible to use columns of any valid MySQL data type other than TEXT or BLOB as partitioning keys, because the internal key-hashing functions produce the correct ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
noblob: Log all columns (same as full), except for BLOB and TEXT columns that are not required to identify rows, or that have not changed. To maximize the amount of space saved, use binlog_row_image=NOBLOB or binlog_row_image=MINIMAL together with ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
Deterministic loadable functions that generate large BLOB values take longer to replicate with row-based replication than with statement-based replication. This is because the BLOB column value is logged, rather than the statement generating the ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
You must increase this value if you are using large BLOB columns or long strings. It should be as big as the largest BLOB you want to use. The MySQL server maintains many system variables that affect its operation. Most system variables can be set ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is available only for tables having no BLOB or TEXT columns. Of the three MyISAM storage formats, static format is the ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. This means they have the binary character set and collation, and comparison and sorting are based on the numeric ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons are case-sensitive. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
It does not validate the key pointer to a clustered record or follow the path for BLOB pointers. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all VARCHAR to CHAR with ALTER TABLE. Each MySQL version is tested on many platforms before it ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
JSON columns and indirect indexing in NDB Cluster It is also possible to use indirect indexing of JSON columns in MySQL NDB Cluster, subject to the following conditions: NDB handles a JSON column value internally as a BLOB. A secondary index defined ...