Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have an EXT3 partition that holds only MySQL dbs. Of 2Tb I'm down to about 90Gb remaining. This should be enough to last me until the new budget starts (and I can get some more storage) but I'm wondering whether the lack of space is causing any problems for MySQL.

share|improve this question

closed as not a real question by Chopper3, Michael Hampton, MadHatter, Ward, Wesley Nov 29 '12 at 17:40

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
You tell us. Are you seeing MySQL problems? –  ceejayoz Nov 13 '12 at 16:41
    
hard to say. the whole system needs to be scaled up. iowait is an increasing issue, though. im just curious if situations like this are adding to it. –  ethrbunny Nov 13 '12 at 16:48

2 Answers 2

up vote 0 down vote accepted

In some cases mysql can create on-disk temporary tables to perform huge complex joins. Sure you need enough free space on disk for that.

If you replicate your bases, binlogs are also stored on disk in addition to the usual files.

Also, we all can forget to turn off debug logging :)

share|improve this answer
    
I know the binlogs are in another partition. Not sure about temp tables though... –  ethrbunny Nov 13 '12 at 17:01

If you are specifically asking if only having 90GB out if 2TB leff will cause MySQL to choke, the answer is no. MySQL will continue to run until the space is exhausted (either by the database files, innodblogs, or tmp tables, then it will stop responding to queries and it hit max connections pretty quick.

If you are using separate InnoDB tables, you can reclaim unused space by issuing an OPTIMIZE TABLE [table name]

For tmp tables, you can move to a ram drive say 1GB (if you have enough ram).

I use:

Create amount point: mkdir /var/ramdisk mount -t tmpfs none /var/ramdisk -o size=1024m

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.