Comment 15 for bug 576041

Peter,

> Can lock dict mutex many times (for each table name lookup) instead of once for all query duration ?

Then the blocking point will move to buf_pool->mutex simply, and the blocking time will be more longer...

I will remove the column 'schema_name', 'table_name' and 'index_name' from INNODB_BUFFER_POOL_PAGES_INDEX,
and add 'table_id' and 'index_id' to the view instead. And get rid of using dict_sys->mutex from the views.

Anyway, such raw feature should not be used by amateur who don't know 'table_id' and 'index_id'.
And the view is used for aggregate the count of the pages anyway?
You should lookup name after the aggregation by using INNODB_SYS_TABLES, INNODB_SYS_INDEXES.