Re: MySQL InnoDB Performance vs Postgres
Any chance you could post SHOW CREATE TABLE for this table ?
Innodb tables are clustered so it would be really interesteing to know what column do you cluster data by.
The other question is - you're mentioning 12G table is it 12G of data or it is how much this table actually takes in Innodb tablespace (data+index)
The fact Optimize is running so long makes me thing you loaded your data in random primary/cluster key order which has serve performance impact for MySQL.
... Also how does SHOW INNODB STATUS looks when you run this query ?
Subject
Views
Written By
Posted
4704
July 20, 2005 03:42PM
2022
July 20, 2005 04:16PM
1983
July 20, 2005 05:12PM
Re: MySQL InnoDB Performance vs Postgres
2226
July 20, 2005 05:27PM
2147
July 20, 2005 07:57PM
2160
July 21, 2005 12:53PM
1980
July 24, 2005 11:36PM
2131
August 03, 2005 12:34PM
2118
July 21, 2005 05:37AM
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.