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-benefits.html
Performance benefits are not limited to large tables with long-running queries. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
This column can be queried to identify tables that reside in encrypted file-per-table tablespaces. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo logs.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
When a key is requested and the associated value is not already in the memory cache, the value is automatically queried from the MySQL test.demo_test table. daemon_memcached_w_batch_size is set to 1 by default so that no uncommitted data is lost in ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
A strict isolation level ensures that data you retrieve is not rolled back or changed suddenly causing subsequent queries to return different values. To avoid potential slowdowns when these tables are used for high-throughput applications, disable ... Unlike traditional memcached, the daemon_memcached plugin allows you to control durability of data values produced through calls to add, set, incr, and so ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB tables. Persistent optimizer statistics are persisted across server restarts, allowing for greater plan stability and more consistent query ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
You can still make changes to session-specific temporary tables in a read-only transaction, or issue locking queries for them, because those changes and locks are not visible to any other transaction. InnoDB can avoid the overhead associated with ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-statistics.html
The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its output. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction ...