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/order-by-optimization.html
(Up to 15 temporary disk files are merged and there must be room in memory for at least one tuple per file.) Take into account that the size of column values stored in the sort buffer is affected by the max_sort_length system variable value. This ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns.html
All of these columns are taken into account both for the purpose of placing rows in partitions and for the determination of which partitions are to be checked for matching rows in partition pruning. The next two sections discuss COLUMNS ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-and-plugins.html
A plugin implementor who instruments plugin code should document its instrumentation characteristics to enable those who load the plugin to account for its requirements. Removing a plugin with UNINSTALL PLUGIN does not affect information already ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-connect-attrs-table.html
To see connection attributes only for the current session, and other sessions associated with the session account, use the session_account_connect_attrs table. Application programs can provide key-value connection attributes to be passed to the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
However, if the special row accounts for a significant percentage of the statements executed, it might be desirable to increase the summary table size by increasing performance_schema_digests_size. The MySQL server is capable of maintaining ...
https://dev.mysql.com/doc/refman/5.7/en/permission-optimization.html
Similarly, if you place no resource limits on any accounts, the server does not have to perform resource counting. The more complex your privilege setup, the more overhead applies to all SQL statements. Simplifying the privileges established by ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
Make sure that you have identified the position accurately, because this statement does not take event groups into account. If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure except where an exception is specifically allowed (see Section 16.4.1.10, “Replication with Differing Table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
The ability to configure the replication mode online means that the gtid_mode and enforce_gtid_consistency variables are now both dynamic and can be set from a top-level statement by an account that has privileges sufficient to set global system ...