I am currently doing some benchmarks for the launch of an online service and I was just concerned about InnoDB maximum table size. I am not touching the topic for performance at the moment.
So my question is quite simple and I think many people already asked it:
- What is the maximum possible size for an InnoDB table?
I have found the easy answer which is 64 TB, but I want to dig a bit to find a real proper answer.
First, I should think that the file system of the server will bring limits. Ext3 can handle maximum 2TB per file and maximum 32 TB for the entire file system with 8k blocks. So this already narrows it to 32TB in my case. Is this a first hard limit that will hit me?
Second, as far as I understood it is possible to place InnoDB files in various system name spaces. One thing I did not understand is how can I specify to InnoDB to store files of X MB (<2TB) for the first 32TB on A device and then continue with extra files of X MB (<2TB) for the second 32 TB and so on.
Third, last but not least what happens when the limit of 32 TB is reached for a table?
I know this is purely paper questions, but I prefer to know before so I can take the right decision and not regret that I have not spent this time now to think on this.
Any hint is most welcome.