User facing option to optimize database tables

[akhilnarang]

Example: delete rows from Data Import Log - storage doesn't get freed up until you run

OPTIMIZE TABLE `tabData Import Log`;

[ankush]

database storage report > action > optimize table > select doctype ??

[niraj2477]

We can optimize both MyISAM and InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html

[akhilnarang]

We can optimize both MyISAM and InnoDB tables.

Yep, had pointed out specifically for MyISAM since the need came about because the storage doesn't get freed up.
Will update title to keep it generic.

[niraj2477]

https://www.postgresql.org/docs/current/sql-vacuum.html

We can have something like frappe.db.optimize() maybe to support for both db 🤔

[ankush]

Btw OPTIMIZE basically rewrites entire table for InnoDB. Optimize call causes a lot of I/O on large tables. People will spam this everywhere without knowing costs of it. It's simple query, doesn't need any special API IMO.

[niraj2477]

rewrites entire table for InnoDB

True. Can be just db.sql in that case, will work on it

[frappe-pr-bot]

🎉 This issue has been resolved in version 15.25.0 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀