|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: slow-query log analysis
From: Soenke Ruempler - NorthClick (sr
northclick.de)
Date: Mon Mar 17 2008 - 13:37:59 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 server had many lookups to tmp and those were slowed
down.
Filesystem is ext3 with dir_index turned-on, noatime on an hardware raid1.
-soenke
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]