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-file-space.html
For example: mysql> SET GLOBAL innodb_segment_reserve_factor=10; How Pages Relate to Table Rows For for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings, the maximum row length is slightly less than half a database page size. For example, the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
Consider decreasing innodb_change_buffer_max_size on a MySQL server with static data used for reporting, or if the change buffer consumes too much of the memory space shared with the buffer pool, causing pages to age out of the buffer pool sooner ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
When should the change buffer be used? The change buffer is a feature designed to reduce random I/O to secondary indexes as indexes grow larger and no longer fit in the InnoDB buffer pool. How do I determine the current size of the change buffer? ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
--max-join-size=value Command-Line Format --max-join-size=value Type Numeric Default Value 1000000 The automatic limit for rows in a join when using --safe-updates. --auto-vertical-output Command-Line Format --auto-vertical-output Cause result sets ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
Starting the server with --skip-host-cache does not prevent runtime changes to the value of host_cache_size, but such changes have no effect and the cache is not re-enabled even if host_cache_size is set larger than 0. Some errors are considered ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. max_relay_log_size: If nonzero, relay log is rotated automatically when its size exceeds this value. If zero, size at which ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
FILE_BLOCK_SIZE is required when you intend to use the tablespace for storing compressed InnoDB tables (ROW_FORMAT=COMPRESSED). If FILE_BLOCK_SIZE is equal the innodb_page_size value, the tablespace can contain only tables having an uncompressed row ...It can hold multiple tables, and supports all table row ...The ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, the amount of storage space used by a given JSON value and the amount of space remaining in a JSON column following a partial update. For a JSON column which has been updated such that ... This section documents utility functions that act on JSON values, or strings that can be parsed as JSON ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
Other reasons for problems with aborted connections or aborted clients: The max_allowed_packet variable value is too small or queries require more memory than you have allocated for mysqld. If connection problems occur such as communication errors ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-transporter-errors.html
This section lists error codes, names, and messages that are written to the cluster log in the event of transporter errors. 0x00 TE_NO_ERROR No error 0x01 TE_ERROR_CLOSING_SOCKET Error found during closing of socket 0x02 ...