List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:December 18 2009 2:55pm
Subject:RE: Innodb buffer pool size filling up
View as plain text  
>-----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: 860.674.8341

www.the-infoshop.com






Thread
Innodb buffer pool size filling upmachiel.richards1 Dec
  • RE: Innodb buffer pool size filling upNeil Aggarwal1 Dec
    • RE: Innodb buffer pool size filling upmachiel.richards1 Dec
      • Re: Innodb buffer pool size filling upClaudio Nanni1 Dec
        • RE: Innodb buffer pool size filling upmachiel.richards1 Dec
          • Re: Innodb buffer pool size filling upClaudio Nanni1 Dec
          • RE: Innodb buffer pool size filling upJerry Schwartz1 Dec
            • RE: Innodb buffer pool size filling upmachiel.richards18 Dec
              • Re: RE: Innodb buffer pool size filling upClaudio Nanni18 Dec
                • RE: RE: Innodb buffer pool size filling upmachiel.richards18 Dec
              • RE: Innodb buffer pool size filling upJerry Schwartz18 Dec