SELECT * FROM `INNODB_SYS_TABLES` ORDER BY `SPACE_TYPE` DESC
Filter rows: |
TABLE_ID | NAME | FLAG | N_COLS | SPACE | ROW_FORMAT | ZIP_PAGE_SIZE |
SPACE_TYPE ![]() |
|
---|---|---|---|---|---|---|---|---|
13 | SYS_TABLESPACES | 0 | 6 | 0 | Redundant | 0 | System | |
37 | SYS_VIRTUAL | 0 | 6 | 0 | Redundant | 0 | System | |
14 | SYS_DATAFILES | 0 | 5 | 0 | Redundant | 0 | System | |
11 | SYS_FOREIGN | 0 | 7 | 0 | Redundant | 0 | System | |
12 | SYS_FOREIGN_COLS | 0 | 7 | 0 | Redundant | 0 | System | |
134 | emp_nontech/registeration | 33 | 16 | 119 | Dynamic | 0 | Single | |
178 | emp_recruit/undertaking | 33 | 6 | 163 | Dynamic | 0 | Single | |
75 | emp_recruit/passing_exam | 33 | 5 | 60 | Dynamic | 0 | Single | |
33 | phpmyadmin/pma__savedsearches | 1 | 8 | 19 | Compact | 0 | Single | |
118 | emp_nontech/state | 33 | 5 | 103 | Dynamic | 0 | Single | |
59 | emp_recruit/year | 33 | 4 | 44 | Dynamic | 0 | Single | |
155 | emp_recruit/patent_details | 33 | 9 | 140 | Dynamic | 0 | Single | |
26 | phpmyadmin/pma__table_coords | 1 | 8 | 12 | Compact | 0 | Single | |
131 | emp_nontech/typing_mode | 33 | 6 | 116 | Dynamic | 0 | Single | |
17 | mysql/gtid_slave_pos | 1 | 7 | 3 | Compact | 0 | Single | |
130 | emp_nontech/bank_detail | 33 | 10 | 115 | Dynamic | 0 | Single | |
154 | emp_recruit/patent_publish_details | 33 | 9 | 139 | Dynamic | 0 | Single | |
27 | phpmyadmin/pma__table_info | 1 | 6 | 13 | Compact | 0 | Single | |
132 | emp_nontech/undertaking | 33 | 6 | 117 | Dynamic | 0 | Single | |
16 | mysql/innodb_index_stats | 1 | 11 | 2 | Compact | 0 | Single | |
187 | emp_nontech/basic_info | 33 | 31 | 172 | Dynamic | 0 | Single | |
150 | emp_recruit/patents | 33 | 5 | 135 | Dynamic | 0 | Single | |
24 | phpmyadmin/pma__table_uiprefs | 1 | 8 | 10 | Compact | 0 | Single | |
52 | emp_recruit/PI_COPI | 33 | 4 | 37 | Dynamic | 0 | Single | |
15 | mysql/innodb_table_stats | 1 | 9 | 1 | Compact | 0 | Single |
Filter rows: |