Answering the trivial question “How much space does this table take on disk?” is really not a simple request in MySQL – look at the obvious place and you’re likely to get the wrong value. Look at INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES to get the actual file size value for InnoDB tables. Top 20 MySQL tables sorted by size. GitHub Gist: instantly share code, notes, and snippets.

Apr 20, 2016 · Very likely your innodb_buffer_pool_size is too small. It looks like you have declared innodb_buffer_pool_size twice in your config.. I guess the MySQL server takes the second value that is just 80M.