Hi!
>> Can you provide information about how much memory is being saved from 0004+0005?
> Attached the output for a query on catcache/relcache memory context
> data, with output of master and the full patchset.
>
> From Master to 0003, we go from 287872 bytes total to 141312 bytes
> total spent on "index info" contexts (some of which moved into other
> contexts, some new, but a net saving of 130kB). 0004+0005 bring that
> down all the way to 45392 bytes; most of which is just avoiding the
> large overhead of the pre-allocated Blocks of memory, saving another
> 95kB.
I tested your patch with my real world database schema consisting of
38,966 tables and 148,468 indexes. The results are attached. They look
great:
Total used_bytes of all relcache memory contexts shrank from
776 MiB -> 633 MiB. Saving of 143 MiB!
--
David Geier