In article <[EMAIL PROTECTED]>, gerald_clark <[EMAIL PROTECTED]> writes:
> 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. Not necessarily. ibdata files can grow if they are declared with "autoextend", but they don't shrink, even if you're deleting all rows. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
