• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

InnoDB default setting enable file_per_table by default

Rob_108

New Pleskian
Seems to me that this setting should be default with the option for those with specialized considerations to turn it off. My Plesk installation is on CentOS (6) by GoDaddy and there is no way to turn it off when one starts up a new server as Plesk itself is using the database. I am very afraid of exporting, flushing and otherwise changing this database to enable this option manually as I have (just) experienced how this can break the entire installation.

When this option is enabled, one can easily move databases by simply copying the .frm, .MYI and .MYD files to whatever location. This is especially good when the server unexpectedly crashes and you use this opportunity to upgrade the OS or something. It also allows one to shrink this ever expanding db file and index files associated with it. Without enabling this option one cannot shrink these files and they grow ever larger.

Please consider this! It would be really great if there were an option in Plesk itself to choose this.

Thank you for your consideration.
 
Back
Top