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
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.
