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
4612
July 20, 2005 03:42PM
1989
July 20, 2005 04:16PM
1954
July 20, 2005 05:12PM
Re: MySQL InnoDB Performance vs Postgres
2189
July 20, 2005 05:27PM
2119
July 20, 2005 07:57PM
2116
July 21, 2005 12:53PM
1953
July 24, 2005 11:36PM
2104
August 03, 2005 12:34PM
2090
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.