MySQL Forums
Forum List  »  InnoDB

unable to shrink IBDATA1 file
Posted by: P N Narender Babu
Date: August 21, 2019 12:32AM

hello team ,

currently we are on 5.7 version and we have observed that IBDATA1 file is increasing.

Total Size of DB is 21G but under the var/lib/MySQL we have around 55GB in which only IBDATA1 is consuming 25G

Steps taken to over come :- As we are using version 5.7 by default we have innodb_file_per_table = 1 and we have innodb_log_file_size=1G as we have buffer_pool Size as 4G

then we have did restarted the DB but no use …

Solutions in Google sites to take backup , remove files and restore . I cannot do in such way …

thanks in advance :
Narender Babu

Options: ReplyQuote

Written By
unable to shrink IBDATA1 file
August 21, 2019 12:32AM
August 21, 2019 02:12AM
August 21, 2019 10:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.