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-table-constraints-table.html
The UNIQUE and PRIMARY KEY information is about the same as what you get from the Key_name column in the output from SHOW INDEX when the Non_unique column is 0. The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 13.7.1.4, “GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
You can monitor adaptive hash index use and contention in the SEMAPHORES section of SHOW ENGINE INNODB STATUS output. The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
The n_diff_pfx% statistics show the columns that are counted for each index. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. The number of indexed columns ...
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-auto-increment-handling.html
If a SHOW TABLE STATUS statement examines the table before the auto-increment counter is initialized, InnoDB initializes but does not increment the value. InnoDB provides a configurable locking mechanism that can significantly improve scalability ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
Monitoring the Buffer Pool Using the InnoDB Standard Monitor InnoDB Standard Monitor output, which can be accessed using SHOW ENGINE INNODB STATUS, provides metrics regarding operation of the buffer pool. The buffer pool is an area in main memory ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
This section builds on the performance tuning advice from Section 14.9.1.3, “Tuning Compression for InnoDB Tables”, and shows how to find problems that might not turn up during initial testing. Overall application performance, CPU and I/O ...