On Sun, Jul 24, 2011 at 7:52 AM, yonatan pingle
<yonatan.pingle@xxxxxxxxx> 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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
