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/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ...mysql> SHOW WARNINGS; +---------+------+---------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------+ | Warning | 1478 | InnoDB: KEY_BLOCK_SIZE requires ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
To install the component, issue an INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
From MySQL 8.0.16, a cache size limit can be set for XCom's message cache using the group_replication_message_cache_size system variable. If the cache size limit is reached, XCom removes the oldest entries that have been decided and delivered. The ... The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
--detailed-info Command-Line Format --encrypt-block-size=# Type Boolean Default Value FALSE Print out file information like --info, but include the file's header and trailer. The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tcp-definition.html
(NDB 8.0.13) Specifies the size of the buffer used when receiving data from the TCP/IP socket. The default size of the send buffer is 2MB, which is the size recommended in most situations. The minimum size is 64 KB; the theoretical maximum is 4 GB.
https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications. The logical model, with objects such as databases, tables, ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts. Table 18.2 MyISAM Storage Engine Features Feature ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
If an unusually large event exceeds this size, the transaction is held until all the applier worker threads have empty queues, and then processed. Waited due to the total size The number of times that the coordinator thread had to wait to schedule ... On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
When row-based binary logging is used, the binlog_row_event_max_size system variable and its corresponding startup option --binlog-row-event-max-size set a soft limit on the maximum size of row events. Where possible, rows stored in the binary log ...There are several reasons why a client might want to set binary logging on a per-session basis: A session that makes many small changes to the database might want to use row-based ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the undo tablespace in which it resides. The physical size of an undo log record in the rollback segment is typically smaller than ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...