Re: Problematic ALTER (empty) TABLE performance
Posted by:
Rick James
Date: February 23, 2013 12:16AM
I would expect something like 2x slowdown due to the copy-on-write activity of LVM, not 6x. However, since you have software raid, there could be less caching than for hardware RAID? The LVM activity may require a lot of arm motion -- this may be the answer.
Turn off LVM except when taking a snapshot?
I assume the drives are configured the same.
Subject
Views
Written By
Posted
2229
February 20, 2013 05:50AM
819
February 21, 2013 11:17PM
1051
February 22, 2013 02:58AM
Re: Problematic ALTER (empty) TABLE performance
832
February 23, 2013 12:16AM
1023
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.