How to shrink ibdata1 file?
Since Azure does not allow file-per-table enabling, and data will store in innodb table space(ibdata1). The fragmented pages of ibdata1 file cannot be released and will cause more storage utilization.
We would like to have a feature where we can shrink ibdata1 file to release fragmented pages.
The innodb_file_per_table parameter can be changed from the server parameters in the Azure portal. This can be changed only in the General Purpose and Memory Optimized pricing tiers.
Andrea Lam on behalf of the Azure DB for MySQL team