There will be an increase in IO and a noticeable decrease in performance if the buffer pool is too small. Give it all the memory which is not needed elsewhere. If you can set it a little larger than the size of all your innodb tablespaces that would be good.
Oracle is a very different animal to MySQL! Regards John On Tue, Mar 16, 2010 at 6:46 AM, Machiel Richards <machi...@rdc.co.za>wrote: > Hi all > > > > Maybe someone can assist me with this one. > > > > A while back I requested some information relating to the > MySQL innodb buffer pool size that seems to fill up rather frequently. > > The buffer pool is currently set to 3Gb , and it takes about > 2-3 weeks after a restart to fill up. > > > > Someone replied and stated that this is preferred to be > running at 100% usage as it means that it is running optimally. > > > > However, the oracle guys in our office disagrees with this > and want to know the following: > > > > . If the innodb buffer pool is at 100% full, how will we know when > it needs more buffers > > o i.e. let's say the database starts getting very busy and needs more > buffers, how will we know that it requires this if the buffer pool usage is > already at 100%. > > > > I am fairly new to database administration so no luck in answering them on > this so I would appreciate the assistance. > > > > > > Regards > > Machiel > >