The ibdata tag has no wiki summary.
0
votes
0answers
20 views
'Offline' MySQL backup - server not starting
The MySQL server is no longer starting because the partition is too full. The issue seems to be ibdata (40GB). I wanted to follow these instructions (at 'InnoDB Infrastructure Cleanup')
Now I already ...
0
votes
1answer
22 views
How can Innodb ibdata1 file grows by 5X even with innodb_file_per_table set?
I have innodb_file_per_table set and just today my ibdata1 file jumped from 59M to 323M after I made several changes to an 800M table to reduce it to about 600M. That particular table's .ibd file was ...
1
vote
1answer
54 views
mysql ibdata1 file corrupted or increased unusually
We are using MySQL 5.2 version all InnoDB tables.
I have observed that ibdata1 file got increased very unusually like occupied 500 GB in 2 days.
In last 6 months, it had taken only 6 GB though ...
0
votes
1answer
169 views
ibdata1 grows exponentially when innodb_file_per_table is configured
I Have installed a MySQL Cluster with InnoDB (innodb_file_per_table enabled subsequently), but since I switched to innodb_file_per_table, the file ibdata1 grows (2GB at month).
Is My my.cnf file is ...
4
votes
1answer
132 views
I have multiple ibdata files : What should I do with them?
I have 3 different ibdata files on disk. What is the difference between them? Can I remove some of them? The goal is to migrate the files from C: to E:...
I'm on MySQL 5.0.x...
Directory of C:\MySQL ...
1
vote
1answer
144 views
Removing/overwriting sensitive data located in already deleted records in ibdata files
As far as I know, using InnoDB tables with innodb_file_per_table = off does not prevent deleted data from being visible in the ibdata1 file.
I know this is by-design, and that I could switch the ...
1
vote
2answers
2k views
MySql - Clean ibdata1
I have a database that its entire size is ~44GB, out of it ibdata1 is ~35GB that doesnt make sense, the size of the data shouldnt be more then 10GB.
i use the following query to get an esstimation of ...
5
votes
2answers
3k views
Ibdata usage and Recommendations?
I have a Production server
On November 5,2011 the ibdata size was 100G.
In Approximate 3 months it is increased to 200G.So it has just doubled its size.So it is a Huge Data.Currently lvm is 251G.
I ...
