Re: Open tables with Partitioning

[Mattias Jonsson]

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.