|Subject:||Re: Making metadata storage SQL-driven|
|Date:||Thu, 01 Sep 2005 12:36:52 +0100|
Alexander Larsson wrote:
On Thu, 2005-09-01 at 12:21 +0100, Jamie McCracken wrote:For instance the embedded mysql needs no set up and it will work out of the box (its just a shared library) so installation and setup is a non-issue. It has no locking issues as the INNODB stuff in mysql is multi generational so readers and writers dont block each other and its totally safe as a write generates a new copy of a record and the commit on it is atomic so even of there's a power failure during a write corruption will not occur to anything committed.How does this work with shared NFS homedirs? Writes are not atomic there the same way they are for local filesystems, so how could you make the commit atomic.
I dont know the internal details of mysql but generally casue the generation architecture is journalised a new write creates a copy of the exisiting record which once completed will have a flag on the record to indicate whether its committed or not. So once the user has written the changes, the user will call commit to set that flag. If power failure occurs the record will either be committed (the flag set) or not (in which case that copy is discarded and lost forever). To benefit from this forced writes need to be used.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Alexander Larsson Red Hat, Inc alexl@xxxxxxxxxx alla@xxxxxxxxxxxxxx He's an otherworldly soccer-playing photographer from a doomed world. She's a hard-bitten gypsy soap star who dreams of becoming Elvis. They fight crime!
-- Mr Jamie McCracken http://www.advogato.org/person/jamiemcc/ -- nautilus-list mailing list nautilus-list@xxxxxxxxx http://mail.gnome.org/mailman/listinfo/nautilus-list
|<Prev in Thread]||Current Thread||[Next in Thread>|
|Previous by Date:||Re: Making metadata storage SQL-driven, Jamie McCracken|
|Next by Date:||Re: Making metadata storage SQL-driven, Rodrigo Moya|
|Previous by Thread:||Re: Making metadata storage SQL-driven, Alexander Larsson|
|Next by Thread:||Re: Making metadata storage SQL-driven, Alexander Larsson|
|Indexes:||[Date] [Thread] [Top] [All Lists]|