L8YTztQ8

1CREATE TABLE IF NOT EXISTS table_name_today (
2id MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
3device BINARY(16) NOT NULL,
4data BLOB NOT NULL,
5DataTime DATETIME NOT NULL ,
6CreateTime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP()
7)TABLESPACE ts_1 STORAGE DISK ENGINE NDBCLUSTER;
8	
9mysql> select node_id, (total-used)/1000000 mbleft, used/1000000 mbused from ndbinfo.memoryusage;
10ndb_mgm> all report memory
11# top
12	
13SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME, FILE_NAME, FILE_TYPE, EXTRA, 
14INITIAL_SIZE/1000000 size_init_mb, 
15MAXIMUM_SIZE/1000000 size_max_mb, 
16TOTAL_EXTENTS - FREE_EXTENTS AS extents_used, 
17(TOTAL_EXTENTS - FREE_EXTENTS) * EXTENT_SIZE/1000000 AS mb_used, 
18FREE_EXTENTS * EXTENT_SIZE/1000000 AS mb_free
19FROM INFORMATION_SCHEMA.FILES WHERE EXTRA IS NOT NULL;