List Info

Thread: Re: High volume (200k+ cached daily) questions




Re: High volume (200k+ cached daily) questions
country flaguser name
United States
2008-03-04 22:53:53
Tim Palmer wrote:

> Thanks for the notes.
> 
> Do you know if you had to do anything special with
mysql?

Sure, I had to up the memory dramatically from the default.
Early on I
noticed that mail was queueing up, the load average was
high, and mysql
was using 100% cpu but not much RAM, which was my clue to
raise that
parameter - when I did so, it made all the difference - RAM
usage went
from around 5% up to 25%, and the load average went down
from 8 to less
than 1. In general, it's just like oracle, the more RAM you
give it, the
happier it is.

I also discovered that the autoextended innodb data file had
grown to 10
times its original size, so I did a dump and restore,
creating 3
generously sized data files. it's been running well since
early 2006.

J









_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )