Date: Wed, 12 Dec 2001 19:41:05 -0800 (PST) From: Tom <tom@uniserve.com> To: David Xu <davidx@viasoft.com.cn> Cc: Andrew Tulloch <andrewt@great4.co.uk>, freebsd-stable@FreeBSD.ORG Subject: Re: SMP and MySQL/threads Message-ID: <Pine.BSF.4.10.10112121937540.60319-100000@athena.uniserve.ca> In-Reply-To: <3C17FA33.3070906@viasoft.com.cn>
next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, 13 Dec 2001, David Xu wrote: > If you need performance, keep it with Linux until FreeBSD 5.0 is ready. > current pthread implement in FreeBSD 4 is user level thread, and all > disk access will > be serialized and whole threads can only run in one processor. Disk access will be serialized? pthreads is all userland, which is true, but all userland programs can issue non-blocking IO requests. pthreads does (must) use nonblocking IO. No one seems to have mentioned any MySQL thread issues. For instance, most MySQL table types serialize all INSERT and UPDATEs. Only one thread can be writing at a time. A new table type fixes this problem, but currently lacks online backup! Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.10.10112121937540.60319-100000>