MySQL Forums
Forum List  »  Partitioning

Re: Open tables with Partitioning
Posted by: Mattias Jonsson
Date: March 02, 2011 08:20AM

If you compare opening 1000 tables to opening one table with 1000 partitions the partitioned table will be faster (only create one table object, one table_share object, only open one .frm file etc, the only thing that will be the same is that both have to create and open 1000 handlers).

The only thing I can come up with, when comparing, is that it will still have to lock each partition for each statement (unless you use LOCK TABLES around a bigger block of statements). So for small/fast queries against a heavily partitioned table there will be overhead for locking all partitions, but if you compare it to a 1000 way join it is still faster ;) Again this is bug#37252...

Options: ReplyQuote

Written By
February 28, 2011 04:56AM
February 28, 2011 10:03AM
March 01, 2011 11:22PM
Re: Open tables with Partitioning
March 02, 2011 08:20AM
March 02, 2011 11:29AM

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.