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-consumer-filtering.html
Conversely, you can get detailed statements in events_statements_current without digests (the DIGEST and DIGEST_TEXT columns are NULL). To enable or disable a consumer, set its ENABLED value to YES or NO. If you disable a consumer, the server does ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-table.html
The events_stages_history table contains the N most recent stage events that have ended per thread. Stage events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, the oldest ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-table.html
The events_statements_history table contains the N most recent statement events that have ended per thread. Statement events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-table.html
The events_transactions_history table contains the N most recent transaction events that have ended per thread. Transaction events are not added to the table until they have ended. When the table contains the maximum number of rows for a given ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-table.html
The events_waits_history table contains the N most recent wait events that have ended per thread. Wait events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, the oldest thread ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The mutex_instances.LOCKED_BY_THREAD_ID and rwlock_instances.WRITE_LOCKED_BY_THREAD_ID columns are extremely important for investigating performance bottlenecks or deadlocks. The Performance Schema is a tool to help a DBA do performance tuning by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-instances-table.html
The file_instances table lists all the files seen by the Performance Schema when executing file I/O instrumentation. If a file on disk has never been opened, it is not in file_instances. When a file is deleted from the disk, it is also removed from ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/performance-schema-performance-timers-table.html
The performance_timers table has these columns: TIMER_NAME The name by which to refer to the timer when configuring the setup_timers table. The rows that do not contain NULL indicate which timers you can use in setup_timers. For an explanation of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. 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 ...