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/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
stage/innodb/alter table (end): Includes any remaining work that appeared after the flush phase, such as reapplying DML that was executed on the table while ALTER TABLE was running. You can monitor ALTER TABLE progress for InnoDB tables using ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-geometry.html
This is the bounding geometry, formed by the minimum and maximum (X,Y) coordinates: ((MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX MINY)) Whether the value is simple or nonsimple. It is a noninstantiable class but has a number of properties, ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
If a timeout value is specified, MASTER_POS_WAIT() stops waiting when timeout seconds have elapsed. The return string has a maximum length of 39 (4 x 8 + 7). The function returns NULL if the replica SQL thread is not started, the replica's source ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
COMPRESS_TIME The total time in seconds used for attempts to compress B-tree pages of size PAGE_SIZE. UNCOMPRESS_TIME The total time in seconds used for uncompressing B-tree pages of the size PAGE_SIZE. COMPRESS_OPS The number of times a B-tree page ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html
Note If the first-time or subsequent manifest download is unsuccessful, an error is logged and you may have limited access to MySQL products during your session. It is downloaded with and supports the following MySQL products: MySQL Servers MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a given state for many seconds, there might be a problem that needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-wait-connected: Time (in seconds) for MySQL server to wait for connection to cluster management and data nodes before accepting MySQL client connections. ndb-wait-setup: Time (in seconds) for MySQL server to wait for NDB engine setup to complete. Ndb_api_wait_exec_complete_count: Number of times thread has been blocked while waiting for operation execution to complete by this MySQL Server (SQL ... The ...