MySQL Forums
Forum List  »  NDB clusters

about ndb fs size
Posted by: Leo Cardia
Date: February 24, 2005 09:02PM

when i insert 44Mb of sqldump file to table using ndb cluster engine
the ndb fs size is very bigger than sql dump file

[root@test bin]# ls -alh cq.sql
-rw-r--r-- 1 root root 44M 24 Feb 22:00 cq.sql

[root@test bin]# du -sh /root/mysqldata/ndb_2_fs/
20M /root/mysqldata/ndb_2_fs/

[root@test bin]# ./mysql -u root -p nas < cq.sql
Enter password:
ERROR 1114 (HY000) at line 58138: The table 'zetyx_member_table' is full

[root@test bin]# du -sh /root/mysqldata/ndb_2_fs/
2.0G /root/mysqldata/ndb_2_fs/

( one server instance nodes / sql, ndb, mgm node at one)

so i checked about (22MB) 58138 record using over 500MB's memory
and using 2GB's filesystem

this is a normal?

we have 4GB of myisam database.
when putting 4GB db to ndb then we requires 800GB Memory, 4TB's hdd disk?

[NDBD DEFAULT]
NoOfReplicas=1
DataMemory=500M
IndexMemory=100M
NoOfFragmentLogFiles=4
MaxNoOfConcurrentOperations=5000
MaxNoOfSavedMessages=12
MaxNoOfAttributes=100
MaxNoOfOrderedIndexes=64

Options: ReplyQuote


Subject
Views
Written By
Posted
about ndb fs size
3755
February 24, 2005 09:02PM
3157
February 25, 2005 08:03AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.