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
7730981116

Options: ReplyQuote


Subject
Views
Written By
Posted
unable to shrink IBDATA1 file
71
August 21, 2019 12:32AM
17
August 21, 2019 02:12AM


Sorry, only registered users may post in this forum.

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.