I want to add innodb_file_per_table statement to my.cnf file.
- Where is it?
- Could I change this file when I have an Online site?
Oops! I was not clear enough, actually I could not find the file (my.cnf)! Where is my.cnf?
Once you add it to my.cnf (wherever it is), make sure you add it as follows:
A mysql restart is required to implement this for all new InnoDB tables. Doing this does not make all the InnoDB tables jump out of ibdata1.
You will also need to tune the InnoDB parameters.
There needs to be some downtime to do this cleanup. Once done, you never have to go about doing it again.
For now, if you want to do it to a live site, you must run this:
I don't know XAMPP that well, but a quick search turned this up:
As for whether you can do this with an online site, you can change it online, but unless you update your my.cnf, the change will be lost after mysql restarts the next time.