MySQL Forums
Forum List  »  Performance

Re: Problematic ALTER (empty) TABLE performance
Posted by: Haron Media
Date: February 23, 2013 03:15AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problematic ALTER (empty) TABLE performance
1022
February 23, 2013 03:15AM


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.