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/structured-system-variables.html
A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit key_cache_age_threshold This section describes the syntax for referring to structured variables. Examples: hot_cache.key_buffer_size ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-doublewrite-buffer.html
Data is written to the doublewrite buffer in a large sequential chunk, with a single fsync() call to the operating system (except in the case that innodb_flush_method is set to O_DIRECT_NO_FSYNC). The default size of a flush list doublewrite file is ... The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multiple-buffer-pools.html
This feature is typically intended for systems with a buffer pool size in the multi-gigabyte range. Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the ... For ...
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/mysql-cluster-ndbinfo-operations-per-fragment.html
Note When using tot_key_writes, you should keep in mind that a write operation in this context updates the row if the key exists, and inserts a new row otherwise. Generally, such a refusal is due to duplicate keys (inserts), Key not found errors ...
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/create-index.html
Functional indexes are implemented as hidden virtual generated columns, which has these implications: Each functional key part counts against the limit on total number of table columns; see Section 10.4.7, “Limits on Table Column Count and Row ...
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
Advantages of table-level locking: Relatively little memory required (row locking requires memory per row or group of rows locked) Fast when used on a large part of the table because only a single lock is involved. Row-Level Locking Table-Level ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
row *************************** Engine: ndbcluster Support: YES Comment: Clustered, fault-tolerant tables Transactions: YES XA: NO Savepoints: NO *************************** 2. row *************************** Engine: CSV Support: YES Comment: CSV ...