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!
Subject
Views
Written By
Posted
567
November 18, 2020 02:18AM
272
November 18, 2020 10:07AM
Re: MySQL Cluster mysql-5.7.30 NDB-7.6.14 page-size
249
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.