PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. The optional INITIAL_SIZE parameter ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-blobs.html
Parts of JSON values exceeding 4000 bytes in size are also stored in this table. The part and (NDB 8.0.30 and later) inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see ...For more information about how NDB Cluster stores columns of such types, see String Type Storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
Ensure that each MySQL server acting as a replication source is assigned a unique server ID, and has binary logging enabled, using the row-based format. If you are using a release of NDB Cluster prior to NDB 8.0.30, you should also consider ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about 100MB per table) on small computer systems. We are not afraid to add extensions to SQL or support for non-SQL features if this greatly increases ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
For example: mysql> SET GLOBAL keycache1.key_buffer_size=128*1024; To destroy a key cache, set its size to zero: mysql> SET GLOBAL keycache1.key_buffer_size=0; You cannot destroy the default key cache. Any attempt to do this is ignored: mysql> SET ... Note As of MySQL 8.0, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-statistics.html
For inserts and updates, this is proportional to the number of columns written, and the size of their data. This statistic increases in size as the utilization of the TCP/IP buffer improves. The NDB management client's CLUSTERLOG STATISTICS command ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-memory-management.html
The innodb_ddl_buffer_size variable, introduced in MySQL 8.0.27, defines the maximum buffer size for online DDL operations. Defining an appropriate buffer size limit avoids potential out of memory errors for online DDL operations that create or ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
The following formula yields the amount of space required: (largest_key + row_pointer_length) * number_of_rows * 2 You can check the length of the keys and the row_pointer_length with myisamchk -dv tbl_name (see Section 6.6.4.5, “Obtaining Table ...If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to ...
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 ...