PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
Instruments time events, which is how the Performance Schema provides an idea of how long events take. Performance Schema Timers Two Performance Schema tables provide timer information: performance_timers lists the available timers and their ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
For InnoDB mutexes that are instrumented, mutex waits can be monitored using Performance Schema. Wait event data collected in Performance Schema tables can help identify mutexes with the most waits or the greatest total wait time, for example. To ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host value is always a specific nonpattern host name. The Performance Schema also counts internal threads and threads for ... When a client connects to the MySQL server, it does so under a particular user name and from a particular ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-model.html
As the Performance Schema collects data, memory is allocated in the corresponding buffer. As the Performance Schema collects data, memory is allocated in the corresponding buffer, until the buffer size reaches N. Data collected by the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-runtime-configuration.html
Specific Performance Schema features can be enabled at runtime to control which types of event collection occur. If you have the UPDATE privilege, you can change Performance Schema operation by modifying setup tables to affect how monitoring occurs. For additional details about these tables, see Section 25.12.2, “Performance Schema Setup ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. The discussion here relies on the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT * FROM performance_schema.setup_instruments; ... Events ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html
Idle Instrument Elements The idle instrument is used for idle events, which The Performance Schema generates as discussed in the description of the socket_instances.STATE column in Section 25.12.3.5, “The socket_instances Table”. Instruments ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...The depth of the nested events stack is greater than the limit imposed by the ...