Absolutely. You don't want to obscure the cause by just throwing more hardware at things. That approach just buys you time until a bigger pile hits the fan if the underlying issue remains unresolved. At the same time, though, 8 MB production innodb buffer pool allocation should be fairly high on the list of things to scrutinize. Kyong
On Wed, Jun 9, 2010 at 12:12 PM, Johan De Meersman <vegiv...@tuxera.be> wrote: > On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim <kykim...@gmail.com> wrote: >> If the memory is available, why not use it? It seems like the default >> buffer pool size out of the box was just never changed. > > Agreed, of course, but if something happens on a system that is out of > the ordinary, it's very good practice to hunt the cause down before it > makes more undesireable things happen. > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org