PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning.html
Note Table partitioning differs from partitioning as used by window functions. In MySQL 9.7, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 9.7 does not currently support partitioning of tables using any storage engine ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-clone-status-table.html
The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains one row of data, or is empty. The clone_status table has these columns: ID A unique cloning operation identifier in the ...
https://dev.mysql.com/doc/refman/9.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/9.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/9.7/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. The host_cache_size system variable controls the size of the host cache, as well as ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-performance-timers-table.html
For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle timer, the frequency is generally related to the CPU speed. For example, on a system with a 2.4GHz processor, the CYCLE may be ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...