Re: Problematic ALTER (empty) TABLE performance
Thanks for your reply.
Yes, the only difference is that cpanel server has ext4 over LVM over mdadm RAID 1, and the non-cpanel (faster) has no LVM, it's ext4 over mdadm RAID 1 partitions directly.
As for the engines, the tables are mixed MyISAM, InnoDB, but the one being altered is InnoDB. Same set of queries used to create and alter tables, so yeah.
Subject
Views
Written By
Posted
2229
February 20, 2013 05:50AM
819
February 21, 2013 11:17PM
Re: Problematic ALTER (empty) TABLE performance
1051
February 22, 2013 02:58AM
833
February 23, 2013 12:16AM
1023
February 23, 2013 03:15AM
778
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.