Now you can obtain hierarchical information for the table, tablespace, and log file group like this: 

## 23.5.14.23 The ndbinfo dict_obj_types Table 

mysql> SELECT indented_name FROM ndbinfo.dict_obj_tree -> WHERE root_name = ’test/def/dt_1’; +----------------------------+ | indented_name | +----------------------------+ | test/def/dt_1 | | -> sys/def/23/last_name | | -> NDB$INDEX_25_CUSTOM | | -> sys/def/23/PRIMARY | | -> NDB$INDEX_24_CUSTOM | +----------------------------+ 5 rows in set (0.15 sec) mysql> SELECT indented_name FROM ndbinfo.dict_obj_tree -> WHERE root_name = ’ts_1’; +-----------------+ | indented_name | +-----------------+ | ts_1 | | -> data_1.dat | | -> data_2.dat | +-----------------+ 3 rows in set (0.17 sec) mysql> SELECT indented_name FROM ndbinfo.dict_obj_tree -> WHERE root_name LIKE ’lg_1’; +-----------------+ | indented_name | +-----------------+ | lg_1 | | -> undo_1.log | | -> undo_2.log | +-----------------+ 3 rows in set (0.16 sec) 

The dict_obj_tree  table was added in NDB 8.0.24. 

The dict_obj_types  table is a static table listing possible dictionary object types used in the NDB kernel. These are the same types defined by Object::Type  in the NDB API. 

## 23.5.14.24 The ndbinfo disk_write_speed_base Table 

The dict_obj_types  table contains the following columns: 

• type_id 

The type ID for this type 

• type_name 

The name of this type 

The disk_write_speed_base  table provides base information about the speed of disk writes during LCP, backup, and restore operations. 

The disk_write_speed_base  table contains the following columns: 

• node_id 

