2 messages in com.mysql.lists.clusterMySQL Cluster and TEXT columns
FromSent OnAttachments
Simon Garner01 May 2005 22:34 
Mikael Ronström01 May 2005 22:49 
Subject:MySQL Cluster and TEXT columns
From:Simon Garner (sgar@expio.co.nz)
Date:05/01/2005 10:34:59 PM
List:com.mysql.lists.cluster

Hi all,

In the manual it states that NDB treats all columns as fixed length, so e.g. a VARCHAR(255) takes up 255 (actually 300) bytes of memory even if it does not contain this much data.

It doesn't say whether this applies to TEXT and BLOB columns as well. This would really hurt if every TEXT column consumes 64KB (or 4GB for a LONGTEXT!) regardless of data size.

Is this true?

-Simon