I’ve been working a lot with xtradb versions of mysql over the last year, and more and more have begun to attempt to leverage the information_schema instrumentation that has been put in place.
Today, I went into a system with this install (admittedly a very recent one)
Server version: 5.1.51-rel11.5-log Percona Server (GPL), 11.5, Revision 132
At this point, I’m at a loss of how to get information on which tables/indexes are using space (and how much) in the buffer pool. I had used INNODB_BUFFER_POOL_PAGES_INDEX to do this in the past. Hopefully documentation will be forthcoming on the new table structures. Admittedly, I haven’t dug too deeply into the new structures (since they are not documented). I’m curious if anyone else has worked with the newer table structures:
Interested in working with Laine? Schedule a tech call.