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