Working on upgrades from 1.8 to 2.0/2.2 and just noticed the index on history tables is not of type primary - this forces MySQL/InnoDB to create a hidden primary key anyway and wastes about 100GB of space, plus time, etc.
The trend tables are correct and have a single primary key.
The upgrade to 2.x doesn't change this.
Anyone know why it's like this ? Maybe a holdover from 1.4/1.6 ?
Any reason we shouldn't change it after/during upgrade ? Would save space and time.
The trend tables are correct and have a single primary key.
The upgrade to 2.x doesn't change this.
Anyone know why it's like this ? Maybe a holdover from 1.4/1.6 ?
Any reason we shouldn't change it after/during upgrade ? Would save space and time.