Go Back   cPanel Forums > cPanel® and WHM® (for Linux® and FreeBSD® Servers) > cPanel and WHM Discussions
MySQL quota exceed MySQL quota exceed
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-15-2009, 08:46 AM
Registered User
  
Join Date: Jun 2007
Posts: 3
CyberCr33p is on a distinguished road
MySQL quota exceed
When user filesystem quota exceed, and mysql tries to write on a database, mysql locks EVERY table/database and waits for some free disk to finish the write.

So every website that uses php/mysql is down until the user deletes some files.

How cpanel handles this issue?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-16-2009, 09:12 AM
cpanelkenneth's Avatar
cPanel Quality Assurance
  
Join Date: Apr 2006
Posts: 3,349
cpanelkenneth is on a distinguished road
Don't apply user quotas to MySQL at the file system level. MySQL was not designed for file system quotas. It should work adequately for group quotas.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
hang , lock , mysql , quota

« SourceGuardian + eAccelerator | cPanel and Chinese character domain names »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -5. The time now is 10:25 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
© cPanel Inc