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-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. NON_UNIQUE 0 if the index ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. TABLE_TYPE BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
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 TP_THREAD_GROUP_STATE table has these columns: TP_GROUP_ID The thread group ID. There is at most ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. The adaptive ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/innodb-compression-tuning-monitoring.html
Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your application. This section builds on the performance tuning advice from Section 14.9.1.3, “Tuning ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed.
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
This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock Detection”. It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications.