MySQL Forums
Forum List  »  Partitioning

Open files with InnoDB
Posted by: Shlomi Noach
Date: March 14, 2007 12:34PM

Hi,

>However growing number of
>partitions will mean more files to open (a bit dependent on the
>storage engine used)

I would very much like to understand how InnoDB handles partitions. It is my understanding that InnoDB keeps using the one single huge sized ibdata1 file (at least this is what I see when I partition an InnoDB table).

So how is the storage distributed, and what is the benefit if all is still inside one file?
Perhaps I'm wrong and missed something?
If it is as I understand, the number of partitions have no effect on the number of open files, am I correct?

Thanks,
Shlomi

Options: ReplyQuote


Subject
Views
Written By
Posted
6693
March 08, 2007 10:09AM
Open files with InnoDB
4972
March 14, 2007 12:34PM
3648
September 20, 2007 08:36PM
3435
September 12, 2007 11:26AM


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.