MySQL one file per table not working
0
votes
2
answers
549
views
I've followed all of the instructions for enabling the one file per table in MySQL (v8, on Ubuntu 20):
- Added innodb_file_per_table=ON
- Restarted MySQL
- Dumped all databases, one by one.
However, when I import the databases back, everything is written to ibdata1 file.
But, When I create a brand new DB via MySQL Client, and add a random table to it, the data is written to its own folder + table.ibd file.
Any idea what I could be doing wrong?
Few troubleshooting steps I tried:
- Reboot
- show variables like 'innodb_file_per_table'; (Value = ON)
Asked by FlyingZebra1
(113 rep)
Dec 24, 2020, 02:54 AM
Last activity: Dec 25, 2020, 11:23 PM
Last activity: Dec 25, 2020, 11:23 PM