各データノードでどれくらいデータ用にファイルを消費しているか

こんなビューを作成する。

CREATE VIEW Table_Space AS
SELECT FILE_NAME,
(TOTAL_EXTENTS * EXTENT_SIZE)/
(1024*1024) AS 'Total MB',
(FREE_EXTENTS * EXTENT_SIZE)/
(1024*1024) AS 'Free MB',
EXTRA FROM INFORMATION_SCHEMA.FILES
WHERE ENGINE = 'NDBCLUSTER' AND
FILE_TYPE = 'DATAFILE';

mysql> select file_name,(total_extents * extent_size) / (1024*1024), (free_extents * extent_size) / (1024*1024), extra from information_schema.files\G
*************************** 1. row ***************************
file_name: data_1.dat
(total_extents * extent_size) / (1024*1024): 128.0000
(free_extents * extent_size) / (1024*1024): 126.0000
extra: CLUSTER_NODE=2
*************************** 2. row ***************************
file_name: data_1.dat
(total_extents * extent_size) / (1024*1024): 128.0000
(free_extents * extent_size) / (1024*1024): 126.0000
extra: CLUSTER_NODE=3
*************************** 3. row ***************************
file_name: undo_1.dat
(total_extents * extent_size) / (1024*1024): 128.0000
(free_extents * extent_size) / (1024*1024): NULL
extra: CLUSTER_NODE=2;UNDO_BUFFER_SIZE=8388608
*************************** 4. row ***************************
file_name: undo_1.dat
(total_extents * extent_size) / (1024*1024): 128.0000
(free_extents * extent_size) / (1024*1024): NULL
extra: CLUSTER_NODE=3;UNDO_BUFFER_SIZE=8388608
*************************** 5. row ***************************
file_name: NULL
(total_extents * extent_size) / (1024*1024): NULL
(free_extents * extent_size) / (1024*1024): 127.8438
extra: UNDO_BUFFER_SIZE=8388608
5 rows in set (0.03 sec)