Bug #64732 Have row cache in InnoDB to increase memory utilization
Submitted: 22 Mar 2012 8:34 Modified: 22 Mar 2012 9:04
Reporter: Kevin Huang Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.1 5.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: buffer pool, Contribution, innodb, patch, row cache

[22 Mar 2012 8:34] Kevin Huang
Because the buffer pool can only cache the page,and when have lots of random small reads,the memory utilization is so low,the read performance is also not good.

For the InnoDB,i think add the row cache before the buffer pool can improve this situation.

How to repeat:
read the code

Suggested fix:
Row Cache For Innodb is designed for increase memory utilization when query is Key-Value-like.

See: http://code.google.com/p/row-cache-for-innodb/
[22 Mar 2012 8:35] Kevin Huang
patch for mysql 5.5.21

Attachment: row_cache_for_mysql.5.5.21_2012_03_22.diff (application/octet-stream, text), 99.84 KiB.

[22 Mar 2012 8:35] Kevin Huang
patch for mysql 5.1.48

Attachment: row_cache_for_mysql.5.1.48_2012_03_22.diff (application/octet-stream, text), 130.71 KiB.

[22 Mar 2012 9:04] Valeriy Kravchuk
Thank you for patches contributed.