PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
Suppose that all data nodes should use the same data memory size. To configure them all, create an [ndbd default] section that contains a DataMemory line to specify the data memory size. This is not required to configure a viable NDB Cluster, but be ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
row *************************** TABLE_ID: 71 NAME: test/t1 FLAG: 1 N_COLS: 6 SPACE: 57 ROW_FORMAT: Compact ZIP_PAGE_SIZE: 0 INSTANT_COLS: 0 Table t1 has a TABLE_ID of 71. Also provided are tablespace ROW_FORMAT, PAGE_SIZE, and several other ...There ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions-limitations.html
mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name 'db_row_id' SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. You ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. When the audit log plugin opens the audit log file, it initializes the sequence number to the size of the audit log file, then increments ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples-compression-sect.html
The only compressed page size that the buffer pool contains is 8K. The smallest PAGE_SIZE in INNODB_CMPMEM is used for block descriptors of those compressed pages for which no uncompressed page exists in the buffer pool. Some memory is unusable due ... Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
As the length of the memcached key and values increase, you might encounter size and length limits. InnoDB table limits may be encountered if values exceed 768 bytes in size, 3072 bytes in size, or half of the innodb_page_size value. This section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-send-buffers.html
This means that the size of the send buffer can be adjusted as necessary. To be backward-compatible with existing configurations, this parameter takes as its default value the sum of the maximum send buffer sizes of all configured transporters, plus ... The NDB kernel employs a unified send buffer whose memory is allocated dynamically from a pool shared by all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-files.html
The files table is empty if no disk data objects have been created in NDB. See Section 25.6.11.1, “NDB Cluster Disk Data Objects”, for more information.