[CentOS] lots of small files in a folder on Linux centos

[Ryan Wagoner]

On Sun, Jul 24, 2011 at 7:52 AM, yonatan pingle
<yonatan.pingle at gmail.com> wrote:
> Hi, Alexander
> good suggestions, ill monitor I/O and mysql code, sounds like a code
> related issue and not a centos issue after all.
>
> it runs on ext3  ,i could only guess how to code deals with the dir,
> as it seems to be the site builds the pages using php+mysql for each
> visitor, with about 40K unique visitors a day, that is a lot of I/O.
>
> This looks like an issue with MySQL after all.
> Queries: 48.0M  qps:   66 Slow:    65.0
>
> avg-cpu:  %user   %nice %system %iowait  %steal   %idle
>                     0.97    0.00    0.28   97.91    0.00    0.84
>
>   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15
>
>         0       102      5.30      3.13      2.06
>         2       120      3.14      2.77      2.22
>
> we wait and see,
>  tail -f log-slow-queries.log
> /usr/sbin/mysqld, Version: 5.0.67-community-log (MySQL Community
> Edition (GPL)). started with:
> Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
> Time                 Id Command    Argument
>
>
>
> thank you
>
>
>
> --
> Best Regards,
> Yonatan Pingle
> RHCT | RHCSA | CCNA1

If you are using phpMyAdmin the status page will aid you in tuning
mySQL. Look for values in red. The description will usually tell you
what to adjust to improve performance.

Ryan