MySQL Bugs: #68544: Ability to support multiple buffer pools with per-table assignment

Bug #68544	Ability to support multiple buffer pools with per-table assignment
Submitted:	1 Mar 2013 19:52	Modified:	2 Mar 2013 14:35
Reporter:	Davi Arnaut (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.5	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	buffer pool, pin tables in memory

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Some of systems have a large amount of data and medium write activity, and smaller data with heavy read activity co-located. These systems with large imbalances suffer from bad performance on the smaller but much busier data they support due to buffer pool pressure from the larger data. It would be helpful to provide some mechanism to allocate specific amounts of buffer pool memory to specific tables.

How to repeat:
See described scenario.

Thank you for the bug report.