Date: Wed, 26 Mar 2008 09:09:30 -0400 From: Bill Moran <wmoran@potentialtech.com> To: Da Rock <rock_on_the_web@comcen.com.au> Cc: freebsd-questions@freebsd.org Subject: Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables Message-ID: <20080326090930.c8d318ee.wmoran@potentialtech.com> In-Reply-To: <1206495548.6973.161.camel@laptop2.herveybayaustralia.com.au> References: <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au> <20080323191727.bd9c5237.wmoran@potentialtech.com> <1206315963.6973.84.camel@laptop2.herveybayaustralia.com.au> <34394a3a0803231701n3e125b15nfa866a9dfccfb331@mail.gmail.com> <1206495548.6973.161.camel@laptop2.herveybayaustralia.com.au>
next in thread | previous in thread | raw e-mail | index | archive | help
In response to Da Rock <rock_on_the_web@comcen.com.au>: [massive snip] > > I remember now exactly why I wanted MyISAM- you see the table locking is > exactly what I need for the task. I just need to come up with a method > to ensure what I send to the server does actually get written- or am I > just being paranoid? > > The task I require needs to offer direct sequential access with no > undoing of written data. And given the legality of the task based on > these strict requirements, you can understand my paranoia. Sounds to me that you want something more like a logfile, where you can write a line of data, then fsync the file to guarantee that it's been committed to disk. Of course, depending on how you'll need to access this data later, this may not be the best approach. I don't know the details of how MySQL does or does not guarantee that your data is safely on disk, but I can say that PostgreSQL uses fsync after each commit to ensure you're data can not be lost. From there, it's up to the hardware, so ensure you have quality disks that don't lie about caching, and you'll probably want a battery-backed RAID controller and some sort of disk redundancy (i.e. RAID-10) -- Bill Moran http://www.potentialtech.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080326090930.c8d318ee.wmoran>