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,
We have huge amount of data, and we are planning to use logical
partitioning to divide it over multiple machines/mysql instances. We
are planning to use Intel based machines and will prefer ISAM since
there is not much updates but mostly selects. The main table that
constitutes this much of
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,
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