Re: Problematic ALTER (empty) TABLE performance
LVM cow happens only when you enable snapshot mode, which wasn't. Besides, how do you turn off LVM? The only way would be to rebuild the server without it...
Also, the IOPS are the same on both servers, and iostat shows approx same amount of sectors/sec and bps utilized by the drives. The only difference is 6x more data in MB written by the cpanel server and consequently 6x more time taken.
I need to figure out somehow what does mysqld write to the discs. My guess would be repeated writing of same data for some reason, or some additional data stream.
Thanks for the ideas, though.
Subject
Views
Written By
Posted
2228
February 20, 2013 05:50AM
818
February 21, 2013 11:17PM
1051
February 22, 2013 02:58AM
832
February 23, 2013 12:16AM
Re: Problematic ALTER (empty) TABLE performance
1022
February 23, 2013 03:15AM
777
February 23, 2013 11:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.