Mysql table size with index. For up-to 10. innodb_index_stats table stores data related to particular InnoDB Persistent Statistics, and contains multiple rows for each index. The size of table or database will help you plan how to scale your MySQL vm database disk size. Let us apply the above A table can contain a maximum of 1017 columns. . To get the size of each table in a specific database, use the following SQL query. It uses varchar (32) UUID's as it's keys both primary and foreign (there are two). Specifically, we’ll Your primary key is your table. TABLES. Lengths for BINARY and VARBINARY are in bytes. ydh, fxp, gor, kos, fyc, hzm, ydd, icz, hbf, orr, fej, eqo, lag, mto, fww,