PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
However, if your application requires “five nines” availability, you should use fixed (numeric) IP addresses, since making communication between Cluster hosts dependent on services such as DNS and DHCP introduces additional potential points of ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
You need to find out why a member is lagging behind and fix that or remove the member from the group. Alternatively, another way of fixing the issue specifically in Group Replication is to issue a STOP GROUP_REPLICATION statement and then a START ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/internal-temporary-tables.html
When in-memory internal temporary tables are managed by the MEMORY storage engine, fixed-length row format is used. Columns take only as much storage as needed, which reduces disk I/O, space requirements, and processing time compared to on-disk ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/mysql-cluster-installation.html
This issue is fixed in NDB 8.0.34 and later (Bug #33324817, Bug #33870642). This section describes the basics for planning, installing, configuring, and running an NDB Cluster. Whereas the examples in Section 25.4, “Configuration of NDB ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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 ...