On Sun, Jul 24, 2011 at 4:02 PM, John R. Dennison <jrd@xxxxxxxxxxxx> wrote: > On Sun, Jul 24, 2011 at 03:53:46PM +0300, yonatan pingle wrote: >> >> Yes Ryan, that exactly what i have done. >> he will get the log shortly and i will get some not free beer. > > While I'm all for mysql optimization it's clearly evident from an > earlier posting that your disks are thrashing with insanely high iowait > figures; and while it's _possible_ for this to be caused by mysql you > really have to go out of your way to achieve that type of behavior. > > > > > > John > -- > The best argument against democracy is a five minute conversation > with the average voter. > > -- Winston Churchill > > _______________________________________________ > CentOS mailing list > CentOS@xxxxxxxxxx > http://lists.centos.org/mailman/listinfo/centos > > this is exactly what i was thinking, that's an insane iowait value, taking into consideration its a VM , not the hardware machine , and the fact the he fills up all his ram along with slow queries showing in the log, it's simply bad code and wrong handling of files. -- Best Regards, Yonatan Pingle RHCT | RHCSA | CCNA1 _______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos