PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. On Windows, InnoDB always stores database and table names internally in lowercase. Copying Data Files (Cold Backup Method) You can ...For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new replica server; you might copy individual tables to another instance to develop and test an application, or to a data warehouse server to produce ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
InnoDB uses the information in the rollback segment to perform the undo operations needed in a transaction rollback. Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction ...It ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
How much space does InnoDB use for the change buffer? A.16.5. What is the benefit of the InnoDB change buffer? Buffering secondary index changes when secondary index pages are not in the buffer pool avoids expensive random access I/O operations that ...What types of operations modify secondary indexes and result in change buffering? ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
Using MySQL Enterprise Backup is the recommended method for backing up InnoDB data. Note InnoDB does not support databases that are restored using third-party backup tools. Hot Backups The mysqlbackup command, part of the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 12.9.6, “Fine-Tuning MySQL Full-Text ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. Run the server with change buffering disabled (innodb_change_buffering=0) and do a slow ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). Note The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a technique that predicts what pages might be needed soon based on pages in the buffer pool being accessed sequentially. You control when InnoDB performs a ... A ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL layer. Direct access to InnoDB tables, bypassing the SQL parser, the optimizer, and even the Handler ...The following diagram illustrates how an application accesses data through the daemon_memcached plugin, compared with ...