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-architecture.html
The following diagram shows in-memory and on-disk structures that comprise the InnoDB storage engine architecture. For information about each structure, see Section 14.5, “InnoDB In-Memory Structures”, and Section 14.6, “InnoDB On-Disk ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
InnoDB can handle multiple sessions all reading and writing to the same table at once without sacrificing reliability or high performance. Enable the innodb_file_per_table variable or use general tablespaces to put the data and indexes for tables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. When you are ready to conduct long-term testing and put compressed tables into production, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuration.html
This section provides configuration information and procedures for InnoDB initialization, startup, and various components and features of the InnoDB storage engine. For information about optimizing database operations for InnoDB tables, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-tables.html
For related information and examples, see Section 14.16, “InnoDB INFORMATION_SCHEMA Tables”. INFORMATION_SCHEMA InnoDB tables can be used to monitor ongoing InnoDB activity, to detect inefficiencies before they turn into issues, or to ...As your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
memcached clients are only able to access InnoDB tables that are registered in the innodb_memcache.containers table. For this reason, SASL support is provided to control access to InnoDB tables associated with the daemon_memcached plugin. Building ... Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
When InnoDB has written the redo log files full, it must write the modified contents of the buffer pool to disk in a checkpoint. The size and number of redo log files are configured using the innodb_log_file_size and innodb_log_files_in_group ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value ...The number of indexed columns in a table The number of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. The page compression feature is ...