How to reduce the size of file in innodb_data_file_path (ibdata1) in mariadb without recreate db

0 votes

2 answers

997 views

I have db with innodb tables and use innodb_file_per_table After

OPTIMIZE TABLE db.table

of all tables the size of db on disk reduced (from 3.3G to 2.8G) But size of file ibdata1 is the same (270MB). May be exists any third party solution?

Asked by M-A-X (151 rep)

Sep 28, 2021, 05:27 PM
Last activity: Jan 14, 2024, 08:41 PM

How to reduce the size of file in innodb_data_file_path (ibdata1) in mariadb without recreate db

Related Questions