PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
The following table shows configuration and MADV_DONTDUMP support scenarios that determine whether core files are generated and whether they include buffer pool pages. The following table provides size reduction examples that you might see for a 1GB ... A core file records the status and memory image of a running ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
InnoDB is aware of table locks if innodb_table_locks = 1 (the default) and autocommit = 0, and the MySQL layer above it knows about row-level locks. Otherwise, InnoDB cannot detect deadlocks where a table lock set by a MySQL LOCK TABLES statement or ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
This section discusses the main considerations for I/O and disk space with the default kind of MySQL tables (also known as InnoDB tables): Controlling the amount of background I/O used to improve query performance. Organizing tables into many small ... As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-types.html
Table 8.32, “General Keyring Key Length Limits” shows the general key-length limits. (The lower limits for keyring_aws are imposed by the AWS KMS interface, not the keyring functions.) For keyring plugins, Table 8.33, “Keyring Plugin Key Types ... MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on which keyring plugin is ...
https://dev.mysql.com/doc/refman/8.0/en/locking-issues.html
MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. External locking occurs when the server and other programs lock ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. Table 25.54 Cluster log categories, with default threshold setting Category Default threshold (All data nodes) STARTUP 7 SHUTDOWN 7 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-engines.html
For those unaccustomed to working with NDB, unexpected behaviors can arise due to its distributed nature with regard to transactions, foreign keys, table limits, and other characteristics. The NDB storage engine is implemented using a distributed, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
However, it is also possible to employ user-defined partitioning with NDBCLUSTER tables. This is subject to the following limitations: Only the KEY and LINEAR KEY partitioning schemes are supported in production with NDB tables. The maximum number ... This section discusses the manner in which NDB Cluster divides and duplicates data for ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-plugin-information.html
There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded plugin. The mysql.plugin table shows which plugins have been registered with INSTALL PLUGIN. The ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table ... When storing a large blob containing textual data, consider compressing it ...