MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Re: Optimizing Disk usage: Reducing DATA_FREE of disk based tables
Posted by: Mikael Ronström
Date: February 19, 2018 06:46AM

a) There is no known limit to the number of data files per data space.
b) If it works for you it sounds ok to me
c) There is nothing against using 32k extent size other than that
you will have more pages locked in memory to handle the extent bits.
With 1 GByte data file size you will 4 32 kByte pages locked to memory
(DiskPageBuffer) per data file (4 bits per page of extent bits).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Optimizing Disk usage: Reducing DATA_FREE of disk based tables
1519
Thomas Waibel-BGo
February 18, 2018 05:24AM
Re: Optimizing Disk usage: Reducing DATA_FREE of disk based tables
549
Mikael Ronström
February 19, 2018 06:46AM
Re: Optimizing Disk usage: Reducing DATA_FREE of disk based tables
392
Edwin Desouza
February 19, 2018 01:09PM


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.