partitioning in Mysql limitation prevents some optimizations

Mysql doesn't support following one big table optimization tip, discovered on Sybase trainings:

Place in memory "day" partition of table.
Store "Old" partitions on disk.

All partitions in Mysql 5.1.31 should be under one storage engine.

Searching for way to solve it by managing buffer sizes.