Re: Reduce Index space

[jun kazawa]

Thank you for your answer and technical details.
Our concern is the memory / innodb_buffer_pool_size usage ; my initial question was vague, please consider the information below.

The huge table has huge indexes. While indexes are binary trees and InnoDB implements the LRU algorithm, there are many accesses from the Internet and users are likely to seek random data implying - imo - many changes in the LRU tables.
This probably forces InnoDB to load more or less the whole index in memory / pool_buffer.

Thus by performing a split of the table - denying access to the 1st table / older data - the query sould run on a smaller table / index, and should take less memory, hopefully(?).

Is there a command to assess the amount of innodb_buffer_pool_size being actively used (probably Innodb uses as much as it can, but what we would like to know is wether the innodb_buffer_pool_size would need an memory extension or no).

Thanks and regards