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 09:02:43 AM
List:com.mysql.lists.cluster

non blob (aka TEXT/BLOB) data is on disk.

you mean: now blob .. ?

all other data is in memory.

If the table is a "disk table" (we cannot yet specify "disk attribute" from MySQL) then

- primary key and any indexed attributes are in memory - other normal attributes are on disk - blob "in-row" (size info and a few initial bytes) is in memory - blob parts (in the parts table) are on disk

-- Pekka Nousiainen, Software Engineer MySQL AB, www.mysql.com pek@mysql.com +358 44 914 2237 / +46 73 632 86 92