List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:July 7 2004 9:06pm
Subject:Re: Space is filling up
View as plain text  

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
>


Thread
Space is filling upAsif Iqbal7 Jul
  • Re: Space is filling upgerald_clark7 Jul
    • Re: Space is filling upAsif Iqbal7 Jul
      • Re: Space is filling upJustin Swanhart7 Jul
RE: Space is filling upJack Coxen7 Jul
  • Re: Space is filling upgerald_clark7 Jul
  • Re: Space is filling upAsif Iqbal9 Jul
  • Re: Space is filling upgerald_clark9 Jul
  • Re: Space is filling upHarald Fuchs9 Jul
  • Re: Space is filling upgerald_clark12 Jul
RE: Space is filling upJack Coxen8 Jul