Harald Fuchs wrote:
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.
And without disk space, he can't dump and reload unless he dumps to tape.
Better verify that tape dump before deleting those innodb files!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
