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/thread-pool-operation.html
To configure the number of thread groups, use the thread_pool_size system variable. Long wait values are useful for workloads that include long-running statements, to avoid starting too many new statements while the current ones execute. A statement ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
For the example password IDs just shown, the corresponding keyring IDs are: audit_log-20190403T142359-1 audit_log-20190403T142400-1 audit_log-20190403T142400-2 The ID of the password currently used for encryption by the audit log plugin is the one ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
Buffer attributes have these meanings: size is the size of the internal record used by the implementation, such as the size of a row in a table. For example, events_waits_history.count corresponds to performance_schema_events_waits_history_size (the ...SHOW ENGINE INNODB MUTEX does not list mutexes and rw-locks for each buffer pool block, as the amount of output would be overwhelming on systems with a large buffer ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched into. ndb-blob-write-batch-bytes: Specifies size in bytes that large BLOB writes should be batched into. ndb-default-column-format: Use this value (FIXED or ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
This may not entirely prevent running out of file descriptors because in some circumstances the server may attempt to extend the cache size temporarily, as described in Section 10.4.3.1, “How MySQL Opens and Closes Tables”. If you get ERROR ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
row *************************** id: 1 select_type: PRIMARY table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4 filtered: 33.33 Extra: Using where *************************** 2. row ...Its value is a set ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
By default, the table is autosized, but if this size is too small, set the performance_schema_digests_size system variable to a larger value at server startup. The QUERY_SAMPLE_TEXT, QUERY_SAMPLE_SEEN, and QUERY_SAMPLE_TIMER_WAIT columns also are ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For example, adding a very small floating-point value to a very large value causes the very small value to be “hidden” by the large value. When inverting the large value later, the effect of the small value is lost. For EXPLAIN, windowing ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
The actual compression algorithm is not affected by the KEY_BLOCK_SIZE value; the value determines how large each compressed chunk is, which in turn affects how many rows can be packed into each compressed page. After the innodb_file_per_table ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-query-expansion.html
This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. For example, a user searching for “database” may really mean that “MySQL”, ...