MySQL Forums
Forum List  »  NDB clusters

Re: MySQL Cluster mysql-5.7.30 NDB-7.6.14 page-size
Posted by: J SLEEP
Date: November 19, 2020 09:46PM

Dear Jon:
Thank you for your reply!

Here's what happened:
I was migrating data from sysbase database to the disk tables in the MySQL Cluster database. The size of a table was 13G in the SYsbase database, but 125G was taken when the table data was moved to the MySQL Cluster database. (The four NDB were divided into two groups)
Check the properties data_length and max_data_length by 'SHOW TABLE STATUS FROM CS WHERE NAME='TAB' and find that data_length is 1.5g and max_data_length is 125G.
I was wondering how to set max_data_length down, which is about the same size as the table data in the Sysbase database.
I have checked MySQL Cluster data table space, truncate TABLE TAB, this table space is 125G free.
I've looked at MySQL table Spaces that other people are using, not NDBcluster,max_data_length=0.
These are my puzzles.
thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Cluster mysql-5.7.30 NDB-7.6.14 page-size
207
November 19, 2020 09:46PM


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.