Re: MySQL performance problem on MacOS X

[Ken Whitcomb <ken@xxxxxxxxxxxxxx>]

So if I understand your post and the link correctly, the choice is 
between performance and data integrity. If I were in an environment 
where I knew that my backup power would not fail me, I might consider 
the speed option. On the other hand, regardless of the OS, I'm not sure 
that I want my customer's db spending part of it's time in limbo in a 
disk cache. I think that any OS other than MOSX that runs MySQL should 
consider some sort of script that'll flush the disk cache on some 
reasonable period.

Ken Whitcomb

On Jun 6, 2005, at 11:26 AM, David Kazias wrote:

> People who actually know what's going on have placed the problem right 
> at
> the feet of the fact that under OS X MySQL defaults to performing a 
> full
> flush of the hard disk cache to ensure that a transaction has been 
> written
> to disk, whereas under Linux it doesn't.
>
> http://lists.apple.com/archives/darwin-dev/2005/Feb/msg00072.html
>
> Supposedly you can turn this off, but I've not bothered to look for 
> how.
---------
Tenon Intersystems' iTools Mailing List
To unsubscribe: send mail to 
itools-request@xxxxxxxxxxxxxxx
with the body only containing: 
unsubscribe
Find the searchable mailing list archives 
at:
http://www.tenon.com/lists/html/iTools/