From: Martin Gainty Date: May 21 2010 10:34am Subject: RE: Database Quotas List-Archive: http://lists.mysql.com/mysql/221646 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_913165d2-f836-449c-b2db-afa1d58046d4_" --_913165d2-f836-449c-b2db-afa1d58046d4_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Tim- if MYSQL attempts to insert more bytes than what is available on disk you w= ill get 28 ENOSPC No space left on device http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html does this help? Martin Gainty=20 ______________________________________________=20 Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit= =E9 =20 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen.Ce message est confidentiel et= peut =EAtre privil=E9gi=E9. Si vous n'=EAtes pas le destinataire pr=E9vu= =2C nous te demandons avec bont=E9 que pour satisfaire informez l'exp=E9dit= eur. N'importe quelle diffusion non autoris=E9e ou la copie de ceci est int= erdite. Ce message sert =E0 l'information seulement et n'aura pas n'importe= quel effet l=E9galement obligatoire. =C9tant donn=E9 que les email peuvent= facilement =EAtre sujets =E0 la manipulation=2C nous ne pouvons accepter a= ucune responsabilit=E9 pour le contenu fourni. =20 > Date: Thu=2C 20 May 2010 18:09:42 -0700 > From: tjg@stripped > To: noel.butler@stripped > CC: mysql@stripped > Subject: Re: Database Quotas >=20 > > Ummm=2C you're going to have the same problem either way when > > the limit is reached=2C be it a MySQL quota or system quota=2C > > if its full=2C its full. >=20 > Yes=2C but mySQL could return a more friendly "you're out of space" messa= ge and not corrupt the data files if a given statement would cause the data= base to exceed its quota (and it could do so in a way that doesn't corrupt = the database files) >=20 > Or it could work the opposite way: check the current usage against the qu= ota before executing a statement=2C and if the database is already over quo= ta=2C don't even attempt it. >=20 > Tim Gustafson > Baskin School of Engineering > UC Santa Cruz > tjg@stripped > 831-459-5354 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped >=20 =20 _________________________________________________________________ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with H= otmail.=20 http://www.windowslive.com/campaign/thenewbusy?tile=3Dmulticalendar&ocid=3D= PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5= --_913165d2-f836-449c-b2db-afa1d58046d4_--