On Tue, Apr 21, 2009 at 2:52 PM, Milan Andric <mand...@gmail.com> wrote: > Hello, > > I have a rather burly Drupal based site that seems to be causing some > problems, today we had a major outage. There are many slow queries > and also mysql related iowait that causes server processes to hang, at > least that is the theory. > > Here you can examine some of the stats on the server: > http://andric.us/load/localdomain/localhost.localdomain.html > > You can see my iowait stats here, which are pretty high: > http://andric.us/load/localdomain/localhost.localdomain-cpu.html > > And I have written to quite some lengh about the symptoms here, if you > are curious. > > http://forum.slicehost.com/comments.php?DiscussionID=3373&page=1 > http://news.ycombinator.com/item?id=543614 > > But the final conclusion is to use memory rather than disk for mysql's > tmpdir setting. So my question is, how does one do this in > debian/unix? Are there any recipes you can share? Should I use tmpfs > vs ramfs? Thanks for your help. >
I went ahead and followed the tmpfs article here ... http://www.bigdbahead.com/?p=121 mysql took it just fine, waiting to see what how it performs, but looks promising. -- Milan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
