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/performance-schema-build-configuration.html
If the Performance Schema was not configured into the server at build time, no row for PERFORMANCE_SCHEMA appears in the output from SHOW ENGINES. It is possible to exclude certain parts of the Performance Schema instrumentation. For example, to ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/performance-schema-instrument-naming.html
This instrument comes into play when a scheduled event begins executing. An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: host_cache: Information from the internal host cache.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
There are some miscellaneous tables that do not fall into any of the previous groups. This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 25.19, “Using the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the original table later, there might be no matches. The Performance Schema avoids using mutexes to collect or produce data, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-runtime-configuration.html
Put the statements for each monitoring configuration into their own file and specify the appropriate file as the init_file value when you start the server. Specific Performance Schema features can be enabled at runtime to control which types of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Statement Digest Aggregation Rules If the statements_digest consumer is enabled, aggregation into events_statements_summary_by_digest occurs as follows when a statement completes. The Performance Schema maintains tables for collecting current and ...