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-information-schema-compression-tables.html
There are two pairs of InnoDB INFORMATION_SCHEMA tables about compression that can provide insight into how well compression is working overall: INNODB_CMP and INNODB_CMP_RESET provide information about the number of compression operations and the ...INNODB_CMPMEM and INNODB_CMPMEM_RESET provide information about the way memory is allocated for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The operation takes a long time and concurrent DML modifies the table so much that the size of ...The changes made by the concurrent DML take precedence, and the ALTER TABLE operation is effectively rolled ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM ...
https://dev.mysql.com/doc/refman/8.0/en/json-functions.html
For discussion of the JSON data type and additional examples showing how to use these functions, see Section 13.5, “The JSON Data Type”. Functions that return JSON values always perform normalization of these values (see Normalization, Merging, ... The functions described in this section perform operations on JSON ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. It first checks all index entries for errors and then reads through all rows. It calculates a checksum for all key values in the rows and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-mgmd.html
For detailed descriptions and other additional information about each of these parameters, see Section 25.4.3.5, “Defining an NDB Cluster Management Server”. HeartbeatIntervalMgmdMgmd: Time between management-node-to-management-node heartbeats; ... The listing in this section provides information about parameters used in the [ndb_mgmd] or [mgm] section of a config.ini file for configuring NDB Cluster management ...
https://dev.mysql.com/doc/refman/8.0/en/mysql.html
This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before displaying it. mysql is a simple SQL shell with input line editing capabilities. When used ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-lock-waits-table.html
This information enables you to understand data lock dependencies between sessions. Use the data_lock_waits table to help diagnose performance problems that occur during times of heavy concurrent load. For InnoDB, see the discussion of this topic at ... The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-member-stats-table.html
COUNT_TRANSACTIONS_REMOTE_APPLIED Number of transactions this member has received from the group and applied. COUNT_TRANSACTIONS_LOCAL_PROPOSED Number of transactions which originated on this member and were sent to the group. The ...