1.
I cannot improve innodb_buffer_pool_pages_index if you want columns as it is.
needs to remove name information (db, table, index). To pickup name, dict_sys is needed and
the looking up is slow to be used for all of blocks in BP.
2.
i_s_innodb_buffer_pool_pages.patch
uses mutex in wrong order and may cause deadlock in worse.
I will fix 2. but I cannot fix 1 without contract of function.
Peter, as I mailed.
There seems to be 2 type of problems.
1. buffer_ pool_pages_ index if you want columns as it is.
I cannot improve innodb_
needs to remove name information (db, table, index). To pickup name, dict_sys is needed and
the looking up is slow to be used for all of blocks in BP.
2. buffer_ pool_pages. patch
i_s_innodb_
uses mutex in wrong order and may cause deadlock in worse.
I will fix 2. but I cannot fix 1 without contract of function.