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-benefits.html
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 the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. Example 17.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate ...The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | +-----------------------------------------------+ | INNODB_BUFFER_PAGE_LRU | | INNODB_BUFFER_PAGE | | INNODB_BUFFER_POOL_STATS | +-----------------------------------------------+ Table Overview INNODB_BUFFER_PAGE: Holds information about each page in the InnoDB buffer ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-replicaset-introduction.html
An InnoDB ReplicaSet consists of at least two MySQL Server instances, and it provides all of the MySQL Replication features you are familiar with, such as read scale-out and data security. InnoDB ReplicaSet uses the following MySQL technologies: ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
Data written using the memcached protocol is transparently written to an InnoDB table, without going through the MySQL SQL layer. Data requested through the memcached protocol is transparently queried from an InnoDB table, without going through the ...The combination of InnoDB tables and memcached offers advantages over using either by ...Running memcached in the same ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
You can calculate from these numbers how many data file I/O operations your queries currently are doing. Standard Monitor output is limited to 1MB when produced using the SHOW ENGINE INNODB STATUS statement. The number of seconds is the elapsed time ... The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...SEMAPHORES This section reports threads waiting for a semaphore and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html
InnoDB Cluster uses the following MySQL technologies: MySQL Shell, which is an advanced client and code editor for MySQL. The following diagram shows an overview of how these technologies work together: Figure 23.1 InnoDB Cluster overview Being ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
You can determine the default storage engine on a MySQL Server instance by issuing the following statement: mysql> SELECT @@default_storage_engine; +--------------------------+ | @@default_storage_engine | +--------------------------+ | InnoDB | ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops. The main ...Because the default is to buffer all types of data change operations, only change this setting if you need to reduce the amount of ... Different settings work best for servers ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
Techniques for moving or copying InnoDB tables include: Importing Tables MySQL Enterprise Backup Copying Data Files (Cold Backup Method) Restoring from a Logical Backup Importing Tables A table that resides in a file-per-table tablespace can be ...