6 messages in com.mysql.lists.clusterRe: Do BLOBs count towards the 8k row...
FromSent OnAttachments
Kevin Burton04 Dec 2006 20:53 
Anatoly Pidruchny04 Dec 2006 21:19 
Kevin Burton04 Dec 2006 21:54 
John David Duncan04 Dec 2006 22:04 
Mikael Ronström04 Dec 2006 23:57 
Stewart Smith05 Dec 2006 04:06 
Subject:Re: Do BLOBs count towards the 8k row limit?
From:Stewart Smith (stew@mysql.com)
Date:12/05/2006 04:06:23 AM
List:com.mysql.lists.cluster

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