From: Martin Gainty Date: May 21 2010 3:59pm Subject: RE: Database Quotas List-Archive: http://lists.mysql.com/mysql/221652 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_6e30c2ae-b66c-4feb-abb1-5a1d97def949_" --_6e30c2ae-b66c-4feb-abb1-5a1d97def949_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i guess my thinking is more along the lines of implementing a lustre interf= ace http://en.wikipedia.org/wiki/Lustre_%28file_system%29#Architecture =20 where the chronology *may* follow: the File's Metadata attributes are written the particulars of where the data is written would be handled by OSS which = delegates to 1..n target nodes (which then passes the information to that t= arget's LVM / RAID device) Both MDS and OSS can implement either ext3 or ZFS/DMU Storage algos..in eit= her case the metadata(MDT) metadata object record is written by the MDS .. the data will be written to one or more LOV formatted ext3 or ZFS/DMU nodes= specifying byte-offset and size.. When the requesting client issues a write request for the OST the governing OSS issues the write request to the target that can fulfill i= t..if the requested target cannot complete the request=20 that target passes ENOSPC back to OSS which then looks up the next target The admin of the target node will be notified of the failed attempt by aler= t or log but the OSS will hunt for the next target that can fulfill the write reques= t of the OST =20 this is my (albeit cursory) interpretation of Object Oriented Disk Architec= tures does this conform to your understanding? Martin Gainty=20 ______________________________________________=20 Please do not alter/modify or disrupt this transmission. Thank You =20 > Date: Fri=2C 21 May 2010 07:21:22 -0700 > From: tjg@stripped > To: mgainty@stripped > CC: mysql@stripped > Subject: Re: Database Quotas >=20 > > if MYSQL attempts to insert more bytes than what is available > > on disk you will get 28 ENOSPC No space left on device > > http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.htm= l=20 >=20 > Does it figured that out before it tries to write a record? So=2C if I ha= ve 2KB left on the device and I write a 4KB record=2C does the first 2KB ge= t written and then the error occurs=2C or does the error occur before the w= rite is attempted? >=20 > I guess what I'm asking is will the tables be marked as "crashed" when an= ENOSPC happens=2C or will the tables still be in good health? >=20 > If they're still in good health=2C then I suppose that I could use ZFS fi= le systems to allocate space for databases...it just seems that this ought = to be a feature of the database. :) >=20 > Tim Gustafson > Baskin School of Engineering > UC Santa Cruz > tjg@stripped > 831-459-5354 =20 _________________________________________________________________ Hotmail is redefining busy with tools for the New Busy. Get more from your = inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326::T:WLMTAGL:O= N:WL:en-US:WM_HMP:042010_2= --_6e30c2ae-b66c-4feb-abb1-5a1d97def949_--