unable to shrink IBDATA1 file
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
Subject
Views
Written By
Posted
unable to shrink IBDATA1 file
1714
August 21, 2019 12:32AM
660
August 21, 2019 02:12AM
743
August 21, 2019 03:34AM
639
August 21, 2019 10:26AM
611
August 22, 2019 03:47AM
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.