![]() Trying to reproduce your results above, instead I got an error: | world | test | BASE TABLE | MyISAM | 0.As you mentioned, Innodb is only supported on a second generation Cloud SQL instance. | world | countrylanguage | BASE TABLE | InnoDB | 0.1563 | | world | country | BASE TABLE | InnoDB | 0.0938 | | world | city | BASE TABLE | InnoDB | 0.5156 | | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | TABLE SIZE in MB | Mysql> SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE,(DATA_LENGTH+INDEX_LENGTH)/(1024*1024) as "TABLE SIZE in MB" FROM TABLES WHERE TABLE_SCHEMA='world' | world | test | BASE TABLE | MyISAM | 1024 | ![]() | world | countrylanguage | BASE TABLE | InnoDB | 163840 | | world | country | BASE TABLE | InnoDB | 98304 | | world | city | BASE TABLE | InnoDB | 540672 | | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | TABLE SIZE | Mysql> SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE,DATA_LENGTH+INDEX_LENGTH as "TABLE SIZE"FROM TABLES WHERE TABLE_SCHEMA='world' | information_schema | GLOBAL_VARIABLES | SYSTEM VIEW | MEMORY | | information_schema | GLOBAL_STATUS | SYSTEM VIEW | MEMORY | | information_schema | FILES | SYSTEM VIEW | MEMORY | | information_schema | EVENTS | SYSTEM VIEW | MyISAM | | information_schema | ENGINES | SYSTEM VIEW | MEMORY | | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | | information_schema | COLUMNS | SYSTEM VIEW | MyISAM | | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | Mysql> SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE FROM TABLES LIMIT 10 | TABLE_COMMENT | varchar(2048) | NO | | | | | CREATE_OPTIONS | varchar(255) | YES | | NULL | | | CHECKSUM | bigint(21) unsigned | YES | | NULL | | | TABLE_COLLATION | varchar(32) | YES | | NULL | | | CHECK_TIME | datetime | YES | | NULL | | | UPDATE_TIME | datetime | YES | | NULL | | | CREATE_TIME | datetime | YES | | NULL | | | AUTO_INCREMENT | bigint(21) unsigned | YES | | NULL | | | DATA_FREE | bigint(21) unsigned | YES | | NULL | | | INDEX_LENGTH | bigint(21) unsigned | YES | | NULL | | | MAX_DATA_LENGTH | bigint(21) unsigned | YES | | NULL | | | DATA_LENGTH | bigint(21) unsigned | YES | | NULL | | | AVG_ROW_LENGTH | bigint(21) unsigned | YES | | NULL | | | TABLE_ROWS | bigint(21) unsigned | YES | | NULL | | | ROW_FORMAT | varchar(10) | YES | | NULL | | ![]() | VERSION | bigint(21) unsigned | YES | | NULL | | | ENGINE | varchar(64) | YES | | NULL | | | TABLE_SCHEMA | varchar(64) | NO | | | | | TABLE_CATALOG | varchar(512) | NO | | | | | Field | Type | Null | Key | Default | Extra | | COLLATION_CHARACTER_SET_APPLICABILITY |
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |