MySQL Forums
Forum List  »  NDB clusters

Re: disk data storage and mediumtext column
Posted by: Jonathan Stephens
Date: November 23, 2006 10:29PM

You've got 1300+ rows containing 16kB each. You've probably used up the entire 32MB tablespace. Either increase the initial size of the data file, or add another datafile to the tablespace using ALTER TABLESPACE - see http://dev.mysql.com/doc/refman/5.1/en/alter-tablespace.html for the syntax required to do the latter.

A couple of things to note:

- TEXT and BLOB columns stored in Disk Data tables use a fixed storage size.

- Disk Data data files do not auto-expand. If you need more room, then you need to add more data files.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
1716
November 23, 2006 08:31AM
Re: disk data storage and mediumtext column
1110
November 23, 2006 10:29PM
1004
November 27, 2006 03:18AM
1024
November 29, 2006 04:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.