quota for mysql

I am getting numerous errors which seems to indicate that mysql has reached a quota of some sort, even tho individual virtual servers have not. how can i disable or increase the quota for the mysql server in general. for example:

SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_5bc_0.MYI' (Errcode: 13)



[root@kickback tmp]# quota -v mysql Disk quotas for user mysql (uid 27): Filesystem blocks quota limit grace files quota limit grace /dev/mapper/VolGroup00-LogVol00 1143964 0 0 2118 0 0

Howdy -- it's not likely that MySQL itself has reached a quota... it's possible that a particular Virtualmin user has, but it's also possible that you're seeing a disk space issue.

What output do you receive from these two commands:

df -h
df -i

I found the problem. I was doing some stuff in /tmp and I changed the permissions of /tmp by accident. Once I restored them to the proper permissions, everything is working again. Thanks