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:iqbala-mysql@stripped]
> Sent: Wednesday, July 07, 2004 2:07 PM
> To: gerald_clark
> Cc: mysql@stripped
> 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/mysql?unsub=1
>
