MySQL Forums
Forum List  »  NDB clusters

NDB API:: Column::setInlineSize issue
Posted by: liu huil
Date: September 07, 2015 09:59PM

HI ALL
I use NDB::API do some test about BLOB column,BLOB column is stored in the main table.
i use Column::setInlineSize() set blob column inline size, when the size more than 256, the program has a error: Error in main_cs_ndbapi.cpp, line: 601, code: 4350, msg: Transaction already aborted.
but the size less than 256, the program can work.


1:
Column::setInlineSize

Description. This method gets the inline size of a BLOB column—that is, the number of initial bytes to store in the table's blob attribute. This part is normally kept in main memory, and can be indexed and interpreted.

Important
This method is applicable to BLOB columns only.

Changes made to columns using this method are not visible to MySQL.

2:
Each row in a Cluster BLOB or TEXT column is made up of two separate parts. One of these is of
fixed size (256 bytes), and is actually stored in the original table. The other consists of any data in
excess of 256 bytes, which stored in a hidden table. The rows in this second table are always 2000
bytes long. This means that record of size bytes in a TEXT or BLOB column requires
• 256 bytes, if size <= 256
• 256 + 2000 * ((size – 256) \ 2000) + 1) bytes otherwise

Options: ReplyQuote


Subject
Views
Written By
Posted
NDB API:: Column::setInlineSize issue
1581
September 07, 2015 09:59PM
551
September 09, 2015 03:26AM


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.