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-file-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instance-tables.html
For examples of how to use them for this purpose, see Section 25.19, “Using the Performance Schema to Diagnose Problems” . They provide event names and explanatory notes or status information: cond_instances: Condition synchronization object ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a serialized way (one at a time), which is a potential bottleneck. The mutex_instances table lists all the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-options.html
Options for configuring individual consumers are detailed later in this section. Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
This step is similar to running SHOW PROFILES to identify the Query_ID. The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
If the values in this table for a given timer name are NULL, that timer is not supported on your platform. The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-runtime-configuration.html
This strategy can also be useful if you have multiple monitoring configurations, each tailored to produce a different kind of monitoring, such as casual server health monitoring, incident investigation, application behavior troubleshooting, and so ... Specific Performance Schema features can be enabled at runtime to control which types of event collection ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-rwlock-instances-table.html
This is a counter only, so it cannot be used directly to find which thread holds a read lock, but it can be used to see whether there is a read contention on an rwlock, and see how many readers are currently active. The rwlock_instances table lists ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-consumers-table.html
For detailed information about the effect of enabling different consumers, see Section 25.4.7, “Pre-Filtering by Consumer”. If you disable a consumer, the server does not spend time adding event information to it.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-tables.html
For this reason, some columns in these tables can be changed if you have the UPDATE privilege. The setup tables provide information about the current instrumentation and enable the monitoring configuration to be changed. The use of tables rather ...