[rt-users] MySQL ibdata1/ibdata2 too big

[Asif Iqbal]

Hi All

I noticed my ibdata files in mysql/data dir are almost 4 gig total. Is
there a way I can clean/shrink them without corrupting my rt3 database ?
I have over 200 thousands ticket dated earliest one is mid 2002.

(root)@webrt:/usr/local/mysql/data# du -sh ibdata*
1.9G    ibdata1
2.1G    ibdata2

This is how my conf file looks like

[...]
skip-locking
key_buffer = 1G
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 2M
max_allowed_packet = 512M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 256M
query_cache_type = 1
thread_concurrency = 8
server-id       = 1
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:1882M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

Thanks for any hint/suggestion

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
There's no place like 127.0.0.1