PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/srjs-api-using.html
This section discusses the use of the API in executing and in obtaining and processing results from both simple SQL statements and prepared statements. SQL execution in JavaScript is available in stored procedures only, and not in stored functions.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...