I am curious about this, too. However, I don't think that you answer the
original question.
Are BLOBs stored as separate files, one file per object? Are they combined
into a single large BLOB file? are they aggregated into several medium
sized files? Answering "where are they stored on the disk" may be a better
response as the docs state that they are not stored in the MyISAM table
itself but as "separate objects" (which means what, exactly?)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED]
om To: <[EMAIL PROTECTED]>, <[EMAIL
PROTECTED]>
cc:
06/17/2004 09:17 Fax to:
AM Subject: RE: Where are BLOBs / TEXTs
stored?
Found this at http://dev.mysql.com/doc/mysql/en/BLOB.html, basically
it's not stored in the table row along with any other columns in the
same row.
12.4.2 The BLOB and TEXT Types
Each BLOB or TEXT value is represented internally by a separately
allocated object. This is in contrast to all other column types, for
which storage is allocated once per column when the table is opened.
Ed
-----Original Message-----
From: Luis R. Rodriguez [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 6:37 PM
To: [EMAIL PROTECTED]
Subject: Where are BLOBs / TEXTs stored?
[ Please CC me ]
Hi,
http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
Page says:
---
"The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB
and TEXT column accounts for only five to nine bytes toward this size."
---
Question: So where are BLOBs and TEXTs entries stored?
Luis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
