Hello Marc,
I see that for files, object_instance_begin is always 0 in my tests:
mysql> select * from EVENTS_WAITS_SUMMARY_BY_INSTANCE where
object_instance_begin=0 order by 1 ;
+---------------------------------------------+-----------------------+------------+----------------+----------------+----------------+----------------+
| EVENT_NAME | OBJECT_INSTANCE_BEGIN |
COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT |
MAX_TIMER_WAIT |
+---------------------------------------------+-----------------------+------------+----------------+----------------+----------------+----------------+
| wait/io/file/maria/control | 0 |
6 | 113417304 | 1987986 | 18902884 |
62948886 |
| wait/io/file/maria/log_descriptor_directory | 0 |
2 | 85008924 | 5579574 | 42504462 |
79429350 |
| wait/io/file/maria/recovery_trace | 0 |
7 | 182696514 | 780780 | 26099502 |
60282222 |
| wait/io/file/myisam/dfile | 0 |
1 | 12882870 | 12882870 | 12882870 |
12882870 |
| wait/io/file/myisam/dfile | 0 |
1 | 12924912 | 12924912 | 12924912 |
12924912 |
| wait/io/file/myisam/dfile | 0 |
4 | 24180156 | 1285284 | 6045039 |
13159146 |
| wait/io/file/myisam/dfile | 0 |
3 | 17951934 | 1327326 | 5983978 |
13975962 |
As this is a "by_instance" table (one line per MyISAM data file, the
dfile lines above), I expected a discriminating information to be
present, so that I can know, among the 3 dfile above, which one belongs
to what; for this, I expected file names to show up.
I see that for mutex instances, the column is not 0.
Are the zeroes expected for files?
Thanks!
--
Mr. Guilhem Bichot <guilhem@stripped>
Sun Microsystems / MySQL, Lead Software Engineer
Bordeaux, France
www.sun.com / www.mysql.com
