Submitted by responsiveny on Tue, 07/23/2013 - 14:57
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)
Status:
Active
Comments
Submitted by responsiveny on Tue, 07/23/2013 - 15:00 Comment #1
[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
Submitted by andreychek on Tue, 07/23/2013 - 15:10 Comment #2
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 -hdf -i
Submitted by responsiveny on Tue, 07/23/2013 - 15:43 Comment #3
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