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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.