Best way is to make one file per table and not use default which baloons to a huge file and never shrinks when some tables are removed and unused. See https://www.thegeekstuff.com/2016/02/mysql-innodb-file-per-table Some other reference: …

See https://serverfault.com/questions/42789/how-to-increase-memory-usage-in-mysql-server-to-improve-speed