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/partitioning-range.html
For example, when executing a query such as EXPLAIN SELECT COUNT(*) FROM employees WHERE separated BETWEEN '2000-01-01' AND '2000-12-31' GROUP BY store_id;, MySQL can quickly determine that only partition p2 needs to be scanned because the remaining ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is removed in MySQL 8.0, when the storage engine used for a given table is expected to provide its own (“native”) partitioning handler. Use of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-filtering.html
To enable or disable a consumer, set its ENABLED value to YES or NO. If you disable a consumer, the server does not spend time maintaining destinations for that consumer. For example, if you do not care about historical event information, disable ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
Consequently, values selected from the DIGEST_TEXT column of statement event tables may appear to exceed the performance_schema_max_digest_length value. SELECT_FULL_JOIN Like the Select_full_join status variable, but specific to the statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
For example: mysql> SELECT * FROM performance_schema.events_transactions_current LIMIT 1\G *************************** 1. The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
Assume a join query of the following form that is executed using a table join order of t1, t2, t3: SELECT ... The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
Because the host_cache table exposes the contents of the host cache, it can be examined using SELECT statements. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. Changes to this code occur often, which also affects the set of instruments. It is not practical to list all the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-model.html
This query shows the information associated with the memory instruments: SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/performance_schema/%'; . Memory used depends on the load actually seen, not ...