What is the ibdata1 file in my /var/lib/mysql directory?
Logging in to my Webmin control panel, I noticed that virtually all of my disk space is full. I searched for the ten largest files/ directories on my system and found that a file called ibdata1 is taking up around 94GB of space. It resides in my /var/lib/mysql directory.
What does ibdata1 do? Am I safe to remove it? My assumption is that it's a dump of some kind, but that's just a wild guess.
The file It contains several classes for information vital for InnoDB
You can separate Data and Index Pages from Example
No matter where the InnoDB table is stored, InnoDB's functionality requires looking for table metadata and storing and retrieving MVCC info to support ACID compliance and Transaction Isolation. Here are my past articles on separating table data and indexes from ibdata1
WHAT TO DO NEXTYou can continue having ibdata1 stored everything, but that makes doing LVM snapshots real drudgery (my personal opinion). You need to use My StackOverflow post and shrink that file permanently. Please run this query:
This will tell how much wasted space can be reclaimed after applying the InnoDB Cleanup. | |||||||||
|
출처 - http://serverfault.com/questions/487159/what-is-the-ibdata1-file-in-my-var-lib-mysql-directory
출처 - http://www.scribd.com/doc/31337494/XtraDB-InnoDB-internals-in-drawing
출처 - http://intomysql.blogspot.kr/2010/12/innodb_9912.html
'DB > MySQL' 카테고리의 다른 글
mysql - innodb 용량 늘리기 (0) | 2013.11.06 |
---|---|
mysql - innodb 설정 (0) | 2013.11.06 |
mysql - 권한 정보 테이블(user, db) (0) | 2013.11.01 |
mysql - 한글 정렬 (0) | 2013.05.14 |
mysql 클러스터(cluster) (0) | 2013.03.08 |