gerald_clark wrote: > What about getting a bigger drive? I guess that would be my only option eh?
> > Asif Iqbal wrote: > > >Hi All > > > >My mysql data dir is filled up to 95% and only 345M left. > > > >Here is the dir looks like > > > >1.9G ibdata1 > >3.1G ibdata2 > >3.0K ib_arch_log_0000000002 > >3.0K ib_arch_log_0000000004 > >25K ib_arch_log_0000000000 > >65M rt3 > >67K webrt.err > >70K mysql > >101M ib_logfile0 > >101M ib_logfile1 > > > >Here is my my.cnf file looks like > > > >[..related portion..] > > > >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/ > ># You can set .._buffer_pool_size up to 50 - 80 % > ># of RAM but beware of setting memory usage too high > >innodb_buffer_pool_size = 384M > >innodb_additional_mem_pool_size = 20M > ># Set .._log_file_size to 25 % of buffer pool size > >innodb_log_file_size = 100M > >innodb_log_buffer_size = 8M > >innodb_flush_log_at_trx_commit = 1 > >innodb_lock_wait_timeout = 50 > > > >Any help to clean the dir would be greatly appreciated > > > >Thanks > > > > > > -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
