Ian Barnes wrote:
Im having another problem with a large db. I have a 160Gig drive dedicated
to the database partition and I have on database in particular that is
taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i
have a couple of gig left, but whenever i try and do anything on it, the
disk fills up and I have to run a repair table tablename quick to get it
going and that takes forever since its quite large.
What kind of filesystem is this? I suggest running Linux, and using a
"sensible" filesystem like XFS, possibly
Repairing tables take a long time usually (Falcon is meant to fix this)...
Do you know why the disk is filling up so fast? What MySQL version is
this? And how much *actual* free space do you have?
--
Colin Charles, Community Engineer
MySQL AB, Melbourne, Australia, www.mysql.com
Mobile: +614 12 593 292 / Skype: colincharles
Web: http://www.bytebot.net/blog/
MySQL Forge: http://forge.mysql.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]