Is there any way of calculating number of bytes occupied by the table creation, i know that you can get some information from information_schema.tables but that information is not accurate enough.
What actually required is the number of bytes according to the definition of the table for innodb only and collation could also be considered as utf-8-general-ci
For example a table test is as following
create table test
Now would require to know the total row size that can be accumulated in one row according to the types of columns in the table.
Found a some sort of similar solution in MSSQL but need its MySQL version
Any help is much appreciated.