Hi,
hello:
i have the following table in the database test_transaction
--
-- Table structure for table `test_blob`
--
CREATE TABLE `test_blob` (
`f1` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
i saw the files in the mysql var directory
$ ls -l test_transaction/test_blob.frm
-rw-rw---- 1 mysql mysql 8556 May 12 20:04 test_transaction/test_blob.frm
so this is an approx 8k file.
now i added 2 rows each with binary files of size 8k but when i list
test_blob.frm
the size remains unchanged (still 8556 bytes).
Where are the blob datatypes stored ? i did a bit of reading in the
manual it mentions they are stored in hidden tables ? if so, is it
possible to see these hidden tables and the entries / sizes of rows in
them ?
The .frm file is only the table definition (columns, data types, etc).
The data is stored in the InnoDB tablespace. For MyISAM tables, it is
stored in a .myi file, and for other engines it varies as well.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
