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/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ... This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
When the purge lag exceeds the innodb_max_purge_lag threshold, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge operations to catch up. The InnoDB transaction system maintains a list of transactions that have index ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Using the SET_VAR optimizer hint to update the value of optimizer_switch temporarily, you can enable invisible indexes for the duration of a single query only, like this: mysql> EXPLAIN SELECT /*+ SET_VAR(optimizer_switch = ... MySQL supports ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-plugin-specific.html
keyring_hashicorp_update_config() Associated keyring plugin: keyring_hashicorp When invoked, the keyring_hashicorp_update_config() function causes keyring_hashicorp to perform a runtime reconfiguration, as described in keyring_hashicorp ... For each ...
https://dev.mysql.com/doc/refman/8.0/en/kill.html
During UPDATE or DELETE operations, the kill flag is checked after each block read and after each updated or deleted row. KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
You can use SELECT, DELETE, UPDATE, and INSERT on MERGE tables. You must have SELECT, DELETE, and UPDATE privileges on the MyISAM tables that you map to a MERGE table. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
| wait/synch/mutex/innodb/master_key_id_mutex | YES | YES | +-------------------------------------------------------+---------+-------+ 49 rows in set (0.00 sec) Enable wait event consumers by updating the setup_consumers table. mysql> UPDATE ... A ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-check-options.html
--update-state, -U Command-Line Format --update-state Store information in the .MYI file to indicate when the table was checked and whether the table crashed. myisamchk supports the following options for table checking operations: --check, -c ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
Parameters Introduced in NDB 8.0 The following node configuration parameters have been added in NDB 8.0. AllowUnresolvedHostNames: When false (default), failure by management node to resolve host name results in fatal error; when true, unresolved ...