Re: Using Disk Data - pek...@mysql.com - com.mysql.lists.cluster

15 messages in com.mysql.lists.clusterRe: Using Disk Data

From	Sent On	Attachments
Joe Warren-Meeks	17 Jul 2007 07:48
Brian Moon	17 Jul 2007 08:01
Joe Warren-Meeks	17 Jul 2007 08:07
Stewart Smith	17 Jul 2007 18:05
Brian Moon	17 Jul 2007 19:03
Stewart Smith	17 Jul 2007 20:50
Brian Moon	18 Jul 2007 08:34
pek...@mysql.com	18 Jul 2007 08:50
Brian Moon	18 Jul 2007 08:54
Brian Moon	18 Jul 2007 08:58
pek...@mysql.com	18 Jul 2007 09:02
Robin Bowes	18 Jul 2007 09:09
Brian Moon	18 Jul 2007 09:31
Stewart Smith	18 Jul 2007 21:28
Mikael Ronström	15 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.