what journal options should I use on linux?

2007-03-08 Thread Christopher A. Kantarjiev
I'm setting up mysql on linux for the first time (have been using OpenBSD and NetBSD with UFS until now). The default file system is ext3fs, and I don't mind that, but it seems really silly to use a journaled file system for the database data - doubling my writes. In particular, I have a

Re: stunningly slow query

2006-03-30 Thread Christopher A. Kantarjiev
Mike Wexler wrote: It doesn't really answer your question, but have you tried INSERT DELAYED as a work around? We've not had a lot of luck with this in the past, but it's worth a try. Also the updated status is strange, because that generally indicates that its looking for the record to be

Re: very large key_buffer on amd64?

2005-09-20 Thread Christopher A. Kantarjiev
It appears that mysqld won't start if the setting for key_buffer is more than 2GB. Maybe you've also hit the quirks of memory management and malloc, just as we've posted a while ago in http://lists.mysql.com/mysql/186930 ? It seems to have been a simple issue of not unlimiting the