If you database contains time-based data you could age out old records. I only need to keep data for 6 months so I run a nightly script to delete any records more than 6 months old. And before anyone asks...yes, I also run another script to ANALYZE/OPTIMIZE my tables.
Jack -----Original Message----- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 2:07 PM To: gerald_clark Cc: [EMAIL PROTECTED] Subject: Re: Space is filling up 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]
