Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Purdy (2383)

Purdy
  jasonNO@SPAMpurdy.info
http://purdy.info/
AOL IM: EmeraldWarp (Add Buddy, Send Message)
Yahoo! ID: jpurdy2 (Add User, Send Message)

Bleh - not feeling creative right now. You can check me out on PerlMonks [perlmonks.org].

Journal of Purdy (2383)

Friday November 02, 2001
11:04 AM

Another SysAdmin Tidbit (disk quotas)

[ #1148 ]
While playing around in MySQL, I was getting some strange error messages if using a query that had 'select distinct' or a 'group by'. It would say something like "Cannot write file: /tmp/sassafras: Error 122". (Not really sassafras, but you get my point)

I tried resetting the 'tmp' directory (in case that partition was hokey or something). That didn't work. Then while surfing around the MySQL site, someone mentioned using the perror command. So I did that and it tells me "Disk quota exceeded".

So then I scrambled around to figure out quotas & how they worked on Linux. To find out a users' quota (you may need to be root for all this):

quota -u [userid]

Then to change the quota:

edquota -u [userid]

And voila - problem fixed!

I would like to disable quotas altogether, but I'm using a fancy Cobalt RaQ system and don't want to mess it up too much. Cobalt has a fancy admin website you can use to make those type of changes, BUT only for real userids, not system ids (such as 'mysql').

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.