MySQL Bugs: #37170: MEM does not take multiple instances (multiple key buffers) in account

Bug #37170	MEM does not take multiple instances (multiple key buffers) in account
Submitted:	3 Jun 2008 20:05
Reporter:	Chris Calender	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Advisors/Rules	Severity:	S4 (Feature request)
Version:	1.x,2.x	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	key buffer, Key Buffer Size May Not Be Optimal For System RAM, mem, multiple key cache

Description:
MEM does not take multiple instances (multiple key buffers) in account for the "Key Buffer Size May Not Be Optimal For System RAM" advisor.

For instance, many users run several instances on the same machine.

Within each of these instances, there may be more than one key_buffer.  Say you have 6G of RAM total, 1G allocated to each of 5 instances, then MEM will still tell you that "Key Buffer Size May Not Be Optimal For System RAM" and that you should basically increase the size of your key_buffer.

Also, this raises a second, yet related, feature request, which is for MEM to take multiple key caches into account for this advisor as well.

http://dev.mysql.com/doc/refman/5.0/en/multiple-key-caches.html

How to repeat:
See above. 

Suggested fix:
Scan the my.cnf/my.ini file to look for multiple instances and/or multiple key_caches.