Asif Iqbal wrote:
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.
My databases (mysql,rt3,test) are taking only about 2k.
No. The ibdata* files ARE your database.
You need more disk space, and you need it now.
I am worry about
the ib*log and ibdata* files. Mostly the ibdata files which are taking 5
gig. I am not sure if I can clean those up or rotate or something else
to reclaim the disk space.
(root)@webrt:/usr/local/mysql/data# /usr/local/bin/ls -lh
total 5.2G
-rw-rw---- 1 mysql mysql 25K Jul 4 2003
ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 2.5K Aug 27 2003
ib_arch_log_0000000002
-rw-rw---- 1 mysql mysql 2.5K Aug 28 2003
ib_arch_log_0000000004
-rw-rw---- 1 mysql mysql 100M Jul 8 20:38 ib_logfile0
-rw-rw---- 1 mysql mysql 100M Jun 29 20:23 ib_logfile1
-rw-rw---- 1 mysql mysql 1.9G Jul 8 20:37 ibdata1
-rw-rw---- 1 mysql mysql 3.1G Jul 8 20:33 ibdata2
-rw-r--r-- 1 mysql mysql 1.6K Sep 15 2003 my.cnf
drwxr-x--- 2 mysql mysql 512 Jul 4 2003 mysql
drwx------ 2 mysql mysql 512 Jul 30 2003 newdb
drwx------ 2 mysql mysql 1.5K Jun 30 23:10 rt3
drwxr-x--- 2 mysql mysql 512 Jul 28 2003 test
-rw-rw---- 1 mysql other 67K Nov 21 2003 webrt.err
-rw-rw---- 1 mysql mysql 3 Nov 21 2003 webrt.pid
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]