Em Wed, 01 Nov 2006 00:00:23 -0800, Cabbar Duzayak escreveu:
> We have huge amount of data, and we are planning to use logical
> partitioning to divide it over multiple machines/mysql instances.
This is a hard call. You will have to keep data consistent among
servers, and MySQL does not
Hi,
What been said below is true, I also think you should probably use Merge
table on subsequent table.
While 2G won't be enough for holding the full index for sure, splitting
the table could allow you to have much smaller index and be able to hold
that one in memory. Also if you use dynamic size
Cabbar -
That much data is possible in MySQL; I've seen references to terabyte
databases in the past. 700-800 GB in a single table appears to be
possible but I wouldn't really recommend it. A couple of suggestions,
based on my own reading (I've not worked with such large dbs in MySQL
myself, on
