On Sun, Jul 24, 2011 at 4:02 PM, John R. Dennison jrd@gerdesas.com 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@centos.org 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.