MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 111 to 120 of 129 total results

https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-row-events.html

Character set information is not available in the binary log, which affects string column display: There is no distinction made between corresponding binary and nonbinary string types (BINARY and CHAR, VARBINARY and VARCHAR, BLOB and TEXT). The ...

6.6.9 mysqlbinlog — Utility for Processing Binary Log Files

https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog.html

For example: mysqlbinlog binlog.000001 | mysql -u root -p Or: mysqlbinlog binlog.[0-9]* | mysql -u root -p If the statements produced by mysqlbinlog may contain BLOB values, these may cause problems when mysql processes them. The server's binary ...

15.7.3.4 OPTIMIZE TABLE Statement

https://dev.mysql.com/doc/refman/9.7/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). OPTIMIZE TABLE reorganizes the physical storage of ...

10.6.1 Optimizing MyISAM Queries

https://dev.mysql.com/doc/refman/9.7/en/optimizing-queries-myisam.html

For MyISAM tables that change frequently, try to avoid all variable-length columns (VARCHAR, BLOB, and TEXT). Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk ...

26.2.3 COLUMNS Partitioning

https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html

The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...

26.2.5 KEY Partitioning

https://dev.mysql.com/doc/refman/9.7/en/partitioning-key.html

Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...

26.3.4 Maintenance of Partitions

https://dev.mysql.com/doc/refman/9.7/en/partitioning-maintenance.html

If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... A number of table and ...

13.4.7 Populating Spatial Columns

https://dev.mysql.com/doc/refman/9.7/en/populating-spatial-columns.html

For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom VALUES (ST_GeomFromWKB(X'0101000000000000000000F03F000000000000F03F')); An ODBC application can send a WKB representation, binding it to a placeholder using an ...

19.5.1.21 Replication and max_allowed_packet

https://dev.mysql.com/doc/refman/9.7/en/replication-features-max-allowed-packet.html

If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O (receiver) thread.

15.2.13.1 SELECT ... INTO Statement

https://dev.mysql.com/doc/refman/9.7/en/select-into.html

This is useful for selecting a BLOB value and storing it in a file. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be specified to produce a specific output ...

Displaying 111 to 120 of 129 total results