On Sun, Jul 24, 2011 at 7:52 AM, yonatan pingle yonatan.pingle@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