MySQL Forums
Forum List  »  Partitioning

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

A table with 1000 partitions is still only one table :) so you can still have the same number of table_open_cache (all open handlers for one table instance are linked to that table instance).

Without partitioning one table have one handler/storage engine instance. With partitioning it have the ha_partition handler, which in turn have one handler for each partition. All of these handlers are linked to one table instance, resulting in all these handlers are kept open within one table in the table cache.

So depending on what you mean with a 'table/sub-table' you will get different answers.

But for MyISAM you need to allow enough open files.

So partitioning does not increase any search of the table cache.

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 03:06AM
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.