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-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. For example: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
For example, if analysis shows that the issue is not related to file I/O in a particular storage engine, disable the file I/O instruments for that engine. The Performance Schema is a tool to help a DBA do performance tuning by taking real ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-model.html
This query shows the information associated with the memory instruments: SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/performance_schema/%'; . Memory used depends on the load actually seen, not ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
For capacity planning, reporting the worst case is actually the desired behavior, as it shows what can potentially happen when sessions are uncorrelated, which is typically the case. Operation counts help to understand or tune the overall pressure ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
The rows that do not contain NULL indicate which timers you can use in setup_timers. For an explanation of how event timing occurs, see Section 25.4.1, “Performance Schema Event Timing”. Note As of MySQL 5.7.21, the Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-queries.html
In Section 25.4.3, “Event Pre-Filtering”, an example showed how to pre-filter for file instruments. Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-member-stats-table.html
This table shows statistical information for MySQL Group Replication members. TRANSACTIONS_COMMITTED_ALL_MEMBERS The transactions that have been successfully committed on all members of the replication group, shown as GTID Sets. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-members-table.html
This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should not be confused with the member's internal group communication address ...