Re: slow-query log analysis

2008-03-17 Thread Arthur Fuller
Wow! 70k files in /tmp. Hell of a mistake :) I hope it doesn't happen often. Arthur On 3/17/08, Soenke Ruempler - NorthClick <[EMAIL PROTECTED]> wrote: > > Hi Baron, > > > There were about 70k files in /tmp (caused by a mistake). the web > application on this server had many lookups to tmp and tho

Re: slow-query log analysis

2008-03-17 Thread Soenke Ruempler - NorthClick
Hi Baron, Baron Schwartz wrote: I'd be interested to know what filesystem you're using and how big the directories are. When you say big, do you mean number of entries in the directory, or space used? There were about 70k files in /tmp (caused by a mistake). the web application on this serv

Re: slow-query log analysis

2008-03-17 Thread Baron Schwartz
Hi, On Mon, Mar 17, 2008 at 12:59 PM, Soenke Ruempler - NorthClick <[EMAIL PROTECTED]> wrote: > hi again, > > for those that are interested: the problem was indeed the filesystem > with slow lookups of BIG directories (this had nothing to do with mysql > but caused much iowait and therefore the

Re: slow-query log analysis

2008-03-17 Thread Soenke Ruempler - NorthClick
hi again, for those that are interested: the problem was indeed the filesystem with slow lookups of BIG directories (this had nothing to do with mysql but caused much iowait and therefore the mysql process had been heavily impacted). Soenke Ruempler - NorthClick wrote: I assume that those s