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/information-schema-tp-thread-group-state-table.html
In this case, they go into the reserved state and remain until needed again. The TP_THREAD_GROUP_STATE table has one row per thread group in the thread pool. Each row provides information about the current state of a group. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
(Even if a view is updatable, it might not be possible to insert into it; for details, refer to Section 23.5.3, “Updatable and Insertable Views”.) The IS_UPDATABLE flag may be unreliable if a view depends on one or more other views, and one of ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
If a table fits almost entirely in main memory, a hash index speeds up queries by enabling direct lookup of any element, turning the index value into a sort of pointer. The adaptive hash index enables InnoDB to perform more like an in-memory ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
If you split up related data into different tables, you can set up foreign keys that enforce referential integrity. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
To dig deeper into performance considerations for compressed tables, you can monitor compression performance at runtime using the Information Schema tables described in Example 14.1, “Using the Compression Information Schema Tables”. Overall ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The actual compression algorithm is not affected by the KEY_BLOCK_SIZE value; the value determines how large each compressed chunk is, which in turn affects how many rows can be packed into each compressed page. Compressed tables can be created in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. First, client A creates a table containing one row, and then begins a transaction. The lock cannot be granted because it is incompatible with the S lock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. This section builds on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Organizing tables into many small files, a few larger files, or a combination of both. As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage devices. The ACID design ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-compression-tables.html
There are two pairs of InnoDB INFORMATION_SCHEMA tables about compression that can provide insight into how well compression is working overall: INNODB_CMP and INNODB_CMP_RESET provide information about the number of compression operations and the ...INNODB_CMPMEM and INNODB_CMPMEM_RESET provide information about the way memory is allocated for ...