Probably not. At this point, I'd say his options are limited to either deleting data to free up some space or getting a bigger hard drive. Unless his situation is like mine and he only needs to keep the data for a certain period of time, the bigger hard drive is definitely the way to go. And since hard drives are so cheap now, I'd be tempted to go that route even if he can age out data. I'm seeing ads for 200G drives for $90.00.
Jack -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:06 PM To: 'Asif Iqbal' Cc: [EMAIL PROTECTED] Subject: Re: Space is filling up Jack Coxen wrote: > 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. > But does he even have enough disk space to optimize 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
