Bug #60905 table_io_waits_summary_by_index_usage aggregates non-insert DML wrongly
| Submitted: | 18 Apr 2011 14:31 | Modified: | 22 Apr 2011 13:38 |
|---|---|---|---|
| Reporter: | Mark Leith | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
| Version: | 5.6.2 | OS: | Any |
| Assigned to: | Marc ALFF | CPU Architecture: | Any |
[18 Apr 2011 14:31]
Mark Leith
[18 Apr 2011 14:33]
Mark Leith
session wait stack graph for the above delete cases
Attachment: bug#60905-delete-stack.svg (image/svg+xml, text), 260.13 KiB.
[18 Apr 2011 14:35]
Mark Leith
Results after the two deletes being instrumented only:
mysql> SELECT object_schema,
-> object_name,
-> index_name,
-> count_fetch,
-> count_insert,
-> count_update,
-> count_delete
-> FROM performance_schema.table_io_waits_summary_by_index_usage
-> WHERE object_schema = 'test'
-> AND object_name = 't1';
+---------------+-------------+------------+-------------+--------------+--------------+--------------+
| object_schema | object_name | index_name | count_fetch | count_insert | count_update | count_delete |
+---------------+-------------+------------+-------------+--------------+--------------+--------------+
| test | t1 | i | 2 | 0 | 0 | 0 |
| test | t1 | NULL | 5 | 0 | 0 | 2 |
+---------------+-------------+------------+-------------+--------------+--------------+--------------+
2 rows in set (0.00 sec)
[22 Apr 2011 13:38]
Paul DuBois
Noted in 5.6.3 changelog. Table I/O for the Performance Schema table_io_waits_summary_by_index_usage table was counted as using no index for UPDATE and DELETE statements, even when an index was used. CHANGESET - http://lists.mysql.com/commits/135684
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.