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-parameters.html
For example, to enable or disable the InnoDB adaptive hash index, you can use --innodb-adaptive-hash-index or --skip-innodb-adaptive-hash-index on the command line, or innodb_adaptive_hash_index or skip_innodb_adaptive_hash_index in an option file.
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that row. Similarly, InnoDB maintains a list of locks on a table for table-level locks. If a second transaction wants to ...For a lock to be acquired by a transaction, all incompatible lock requests previously entered into the lock queue for that row or table must be removed (which occurs when the transactions holding or requesting those locks either commit or roll ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
For InnoDB mutexes that are instrumented, mutex waits can be monitored using Performance Schema. The following example demonstrates how to enable InnoDB mutex wait instruments, how to enable associated consumers, and how to query wait event data. To ... A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
This section provides a brief introduction to InnoDB integration with Performance Schema. You can profile certain internal InnoDB operations using the MySQL Performance Schema feature. To use this feature to examine InnoDB performance: You must be ...For comprehensive Performance Schema documentation, see Chapter 25, MySQL Performance ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing InnoDB. Modifying the configuration after InnoDB is initialized ...The locations of MySQL option files are described in Section 4.2.2.2, “Using Option ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If a data dictionary corruption or consistency issue prevents you from starting InnoDB, see Section 14.22.2, “Forcing InnoDB Recovery” for ...If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Increase the value of the innodb_buffer_pool_size configuration option, which performs ...For guidance regarding buffer pool size configuration, see Section 8.12.4.1, “How MySQL Uses ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. InnoDB sends the monitor output to stderr rather than to stdout or fixed-size memory ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system tables. This information comes from the InnoDB internal system tables (also referred to as the InnoDB data dictionary), which cannot be queried ...row *************************** TABLE_ID: 71 NAME: test/t1 FLAG: 1 N_COLS: 6 SPACE: 57 FILE_FORMAT: Antelope ROW_FORMAT: Compact ZIP_PAGE_SIZE: 0 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
If MySQL still has trouble starting because of InnoDB consistency problems, see Section 14.22.2, “Forcing InnoDB Recovery” for steps to start the instance in recovery mode, which permits you to dump the data. InnoDB Crash Recovery To recover ...