We are running with shared tablespace on MySQL database server in our environment. We are looking to enable file per table on database. We want to know
- What would be ideal plan to enable file per table on server ?
- What would be the consequences for same ?
- Is their precautionary steps to be performed ?
- If any issue occurs how can we revert to shared tablespace ?
Database Statistics :
Logical DB size : 860 GB Physical DB size : 1450 GB