On Tue, 2006-12-05 at 08:57 +0100, Mikael Ronström wrote:
Hi,
4.1 and 5.0:
Store 256 bytes in main table and rest in 2000 byte chunks in BLOB
table so the
BLOB table adds 256 bytes to the 8k row limit.
5.1 main memory:
Same thing although the 256 bytes is stored in the variable sized part
of the table (I think, not sure)
Not currently I don't think - although Pekka has said it's relatively
trivial to do so... just down on the TODO list.
5.1 disk data:
Stored in disk part so I don't think it's part of 8k row limit although
I am not sure on this.
but the fields for the BLOB table that are indexed are going to be in
memory.
(this kind of stuff makes my head hurt when writing ndb_size.pl :)
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html