• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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