[rt-users] ibdata/iblogs files grown to 4.5 gig

Asif Iqbal iqbala at qwestip.net
Thu Apr 22 00:34:51 EDT 2004


Hi All

I noticed my ibdata,ib_arch_log and iblog files together is over 4.5 gig
and reached 95% of the disk partition. I have over 250 thousands tickets
running on RT 3.0.9 in Solaris 8 and mysql 4.0.13 with mod_perl1 and
Apache 1.x

I send a request to take the RT training for June 14 at Washington,DC.
However in the meantime I like to find a quick way to rotate the ibdata
and log files if possible or clear it before my partition totally fills
up

Here is how my my.cnf looks like

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

I am running this on a Sun 420R with 4 450 Mhz, 4G mem and 2 18G disks
mirrored to each other

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



More information about the rt-users mailing list