15 messages in com.mysql.lists.clusterRe: Using Disk Data
FromSent OnAttachments
Joe Warren-Meeks17 Jul 2007 07:48 
Brian Moon17 Jul 2007 08:01 
Joe Warren-Meeks17 Jul 2007 08:07 
Stewart Smith17 Jul 2007 18:05 
Brian Moon17 Jul 2007 19:03 
Stewart Smith17 Jul 2007 20:50 
Brian Moon18 Jul 2007 08:34 
pek...@mysql.com18 Jul 2007 08:50 
Brian Moon18 Jul 2007 08:54 
Brian Moon18 Jul 2007 08:58 
pek...@mysql.com18 Jul 2007 09:02 
Robin Bowes18 Jul 2007 09:09 
Brian Moon18 Jul 2007 09:31 
Stewart Smith18 Jul 2007 21:28 
Mikael Ronström15 May 2008 02:39 
Subject:Re: Using Disk Data
From:pek...@mysql.com (pek@mysql.com)
Date:07/18/2007 08:50:28 AM
List:com.mysql.lists.cluster

In 5.1: - first in-row 255 bytes stored in memory (fixed sized column) - rest stored in disk (in the helper table... so some memory is used)

ok, so all varchars are on disk unless they are part of an index then? This is ringing a bell with a presentation I saw at MySQL Conference.

The "in-row" bytes are always in memory, even in latest version. If the table is a disk table, then the blob data (in the separate table) is on disk. Disk does not support var* yet but that hardly matters much.