MySQL Forums
Forum List  »  NDB clusters

Re: MySQL Cluster: "The table is full" with disk storage
Posted by: Mikael Ronström
Date: July 25, 2019 02:19AM

Not 100% sure, but I think the issue is that a TEXT field has a 256 byte
inline part that is stored in memory and the remainder of the parts are
stored on disk. So changing the TEXT to VARCHAR() of suitable size should
do the trick. It will still store the primary key and ordered index and
and hash index in memory for each row. But this should not be more than a
around 400MByte for 4M rows.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Cluster: "The table is full" with disk storage
200
July 25, 2019 02:19AM


Sorry, only registered users may post in this forum.

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.