RE: Innodb buffer pool size filling up

[Jerry Schwartz]

>-----Original Message-----
>From: machiel.richards [mailto:machiel.richards@stripped]
>Sent: Friday, December 18, 2009 12:33 AM
>To: mysql@stripped
>Subject: RE: Innodb buffer pool size filling up
>
>Good Morning all
>
>		QUOTE:	"We have a MySQL database where the
>				INNODB_BUFFER_POOL_SIZE keeps on filling up"
>
>	I have monitored this issue for the last couple of weeks and even
>though the buffer pool usage is increasing slowly, it is still heading to
>become 100% full.
>
[JS] A buffer pool should become 100% full. That is part and parcel of its 
purpose, which is to avoid having to do a physical disk I/O operation.

If a buffer pool never fills up, it is too big.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]

www.the-infoshop.com