Hi, I recently converted some of my tables to innodb from myisam. I don't need transactions or rollback capability, I switched because I needed row-level locking. These are large tables with many rows and lots of INSERTS and UPDATES.
Since changing these tables, I've noticed some large files in my /var/lib/mysql
directory. This is on my test server and I'm running gentoo linux.
The files in this directory look like:
/var/lib/mysql/gentoo1-bin.000001 (1 Gig in size)
/var/lib/mysql/gentoo1-bin.000001 (1 Gig in size)
/var/lib/mysql/gentoo1-bin.000001 (1 Gig in size)
/var/lib/mysql/gentoo1-bin.000001 (1 Gig in size)
...
/var/lib/mysql/gentoo1-bin.000060 (1 Gig in size)
/var/lib/mysql/ibdata1 (10.0 Gig in size)
Since I'm new to innodb tables, I assume that's where these files came from.
Based on these file sizes, I need to get rid of them to save some disk space.
My questions are:
1. Do I need them?
2. Can I delete them?
3. Can I limit the size of the ibdata1 file? Is it too late to resize it?
4. What can I set to reduce the size of these files?
My innodb variables are:
Variable Session value Global value
innodb additional mem pool size 33554432
33554432 innodb
autoextend increment 8
8 innodb buffer pool awe mem mb
0 0
innodb buffer pool size
536870912 536870912
innodb data file path
ibdata1:10M:autoextend ibdata1:10M:autoextend
innodb data home dir
innodb fast shutdown
ON ON
innodb file io threads 4
4 innodb file per table
OFF OFF
innodb flush log at trx commit
1 1
innodb flush method
innodb force recovery
0 0
innodb lock wait timeout 50
50 innodb locks unsafe for
binlog OFF OFF
innodb log arch dir
innodb log archive
OFF OFF
innodb log buffer size 8388608
8388608 innodb log file
size 5242880
5242880 innodb log files in group
2 2
innodb log group home dir ./
./ innodb
max dirty pages pct 90
90 innodb max purge lag
0 0
innodb mirrored log groups
1 1
innodb open files 300
300 innodb table
locks ON ON
innodb thread concurrency
8 8
Please let me know if I need to post any more variables.
Thanks,
Grant
---------------------------------
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new
and used cars.
