PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
This information is used when populating the server_operations and server_transactions tables of the ndbinfo NDB Cluster information database. The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
SPECIFIC_SCHEMA The name of the schema (database) to which the routine containing the parameter belongs. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
DB The default database for the thread, or NULL if none has been selected. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For a comparison of this table with other ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schema-privileges-table.html
The SCHEMA_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 schema belongs. The value can be any privilege ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. 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 ...
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-autocommit-commit-rollback.html
This mode of operation might be unfamiliar if you have experience with other database systems, where it is standard practice to issue a sequence of DML statements and commit them or roll them back all together. If autocommit mode is enabled, each ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
On disk, the change buffer is part of the system tablespace, where index changes are buffered when the database server is shut down. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU utilization. Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 8.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...