Hello everyone,
I guess I have the similar question, that has been brought up.
I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data.
Provided I have very big hard drive, how many partitions at 2GB each could I
allocate? As many as my hard drive can handle?
I also have questions with regards, to a table size. In my case it will be
(4GB)/36 bytes per table? Is it distributed uniformly, or some tables can grow
bigger on the expense of the others (if some only have limited data, and others
keep having new data inserted into them).
Sincerely,