PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-timers-table.html
The setup_timers.TIMER_NAME value can be changed to select a different timer. The value can be any of the values in the performance_timers.TIMER_NAME column. For an explanation of how event timing occurs, see Section 25.4.1, “Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
This column can be grouped on to isolate, for example, client activity from that of the server listening sockets. These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has this summary column containing aggregated values: VARIABLE_VALUE The aggregated status variable value for active and terminated sessions. Note The value of the show_compatibility_56 system variable affects the ...