PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-doublewrite-buffer.html
With this setting, the doublewrite buffer is fully enabled, with database page content written to the doublewrite buffer where it is accessed during recovery to fix incomplete page writes. Database page content is not written to the doublewrite ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
Variable-length types such as VARCHAR are stored using a fixed length. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-table-formats.html
Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you are using. When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC ...The third, compressed format, can be created only with the myisampack utility (see Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
There are no prefix indexes; only entire columns can be indexed. A partial fix for this issue improved the error used internally to work in most cases; however, it remains possible for this situation to occur in the event that the parent index is a ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbd-definition.html
For those parameters affecting memory usage or buffer sizes, it is possible to use K, M, or G as a suffix to indicate units of 1024, 1024×1024, or 1024×1024×1024. Variable-length records use a fixed-size part with an extra overhead of 4 bytes to ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_default_column_format: Sets default row format and column format (FIXED or DYNAMIC) used for ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-connection-attribute-tables.html
FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage Connection Attribute Limits There are limits on the amount of connection attribute data transmitted from client to server: A fixed limit imposed by the client ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...