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-tables-table.html
For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40% to 50%. (This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. Refer to the notes ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
This is a conservative extension if we consider each comma in a list of table_reference items as equivalent to an inner join. Suppose that a join query over 3 tables T1,T2,T3 has this form: SELECT * FROM T1 INNER JOIN T2 ON P1(T1,T2) INNER JOIN T3 ...The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous transactions. This procedure does not require taking the server offline and is suited to use in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. The series is calculated like this: auto_increment_offset + N × auto_increment_increment where N is a positive integer value in the ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. Execute At For a one-time event, this is the ...It requires the EVENT privilege for the database from which the events are to be ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
For guidelines on setting this variable, see Section 5.5.3.4, “Thread Pool Tuning”. This differs from the default thread-handling model that associates one thread with one connection such that a given thread executes all statements from its ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
For partitioned tables, both the single-single and multiple-table forms of this statement support the use of a PARTITION clause as part of a table reference. This option takes a list of one or more partitions or subpartitions (or both). This affects ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
This section provides general guidance about configuring the server and clients for encrypted connections: Server-Side Startup Configuration for Encrypted Connections Client-Side Configuration for Encrypted Connections Configuring Encrypted ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
When a condition occurs in a stored program, the server searches for applicable handlers in the current scope (current BEGIN ... If there are no applicable handlers, the search continues outward with the handlers in each successive containing scope ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.