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/mysql-cluster-programs-ndb-restore.html
These differences can be combined with other schema differences supported by ndb_restore, including changes to blob and text columns requiring the use of staging tables. When converting between character data types and TEXT or BLOB, only conversions ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-transactions.html
Unique key reads have their locks upgraded automatically by NDB to ensure a self-consistent read; BLOB reads also employ extra locking for consistency. NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-internals.html
The compression of B-tree nodes (of both clustered and secondary indexes) is handled differently from compression of overflow pages used to store long VARCHAR, BLOB, or TEXT columns, as explained in the following sections. Compressing BLOB, VARCHAR, ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-row-format.html
Tables that use the REDUNDANT row format store the first 768 bytes of variable-length column values (VARCHAR, VARBINARY, and BLOB and TEXT types) in the index record within the B-tree node, with the remainder stored on overflow pages. This works ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
BLOB and TEXT columns also can be indexed, but a prefix length must be given. That is, index entries consist of the first length characters of each column value for CHAR, VARCHAR, and TEXT columns, and the first length bytes of each column value for ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/9.7/en/memory-use.html
For each concurrent thread, a table structure, column structures for each column, and a buffer of size 3 * N are allocated (where N is the maximum row length, not counting BLOB columns). A BLOB column requires five to eight bytes plus the length of ... MySQL allocates buffers and caches to improve performance of database ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
String: The CHAR, VARCHAR, TEXT, and BLOB string types are supported. The maximum supported length for a LONGTEXT value is 1073741799 (230 - 24 - 23 - 1) characters; for LONGBLOB, the maximum supported length is 2147483639 (231 - 28 - 1). Most ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...