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/sys-host-summary-by-statement-type.html
max_latency The maximum single wait time of timed occurrences of the statement event for the host. These views summarize informaion about statements executed, grouped by host and statement type. total_latency The total wait time of timed ...By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
max_latency The maximum single wait time of timed occurrences of the statement event for the user. These views summarize informaion about statements executed, grouped by user and statement type. total_latency The total wait time of timed ...By ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. For example, if you want to execute mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME, STATEMENT_NAME, SQL_TEXT FROM performance_schema.prepared_statements_instances WHERE OWNER_OBJECT_TYPE ...C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE mysql_stmt_close() COM_STMT_CLOSE The text ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
The log table implementation has the following characteristics: In general, the primary purpose of log tables is to provide an interface for users to observe the runtime execution of the server, not to interfere with its runtime execution. Log ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error and ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
The optimizer choices are limited because only such plans enable outer joins to be executed using the nested-loop algorithm. This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. For example, utf8 characters can require up to three bytes per character, so a VARCHAR column ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
Sometimes it is useful to join a table to itself, if you want to compare records in a table to other records in that same table. The pet table keeps track of which pets you have. If you want to record other information about them, such as events in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. Preparing the NDB Cluster for ...