Heya Folkth: I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog.
Here's the situation... 1/ there are three threads which lock and then write to two different tables...the locks are gotten using 'low_priority write'; the writing threads are continually waiting for locks (i.e two are waiting, one is executing); 2/ I do a select count(*) from one of the tables; Sometimes the select returns pretty quick witht the count; however, frequently the selecting thread will simply hang waiting to get the lock--if I look at the thread in [top] the thread will be taking a LOT of cpu time; if I look at the offending thread in the processlist it has a status of 'waiting for tables'. It's my understanding that the selecting thread should be given the table lock as soon as the writing thread that has the write lock has finished. *All three writing threads keep processing* while the select thread is waiting: I can see their debug output in my terminals. So perhaps this isn't a FreeBSD threading issue? Peter <^_^> -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 6:07 PM To: Jonathan Disher Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Building MySQL with LinuxThreads On Thu, Jan 23, 2003 at 12:55:33PM -0500, Jonathan Disher wrote: > I have been trying, for the past two days, to successfully build MySQL > 3.23.54 using LinuxThreads on a FreeBSD 5.0-RELEASE SMP box. > Unfortunately, I have been unable to get a successful, working build. FWIW, my FreeBSD 4.x LinuxThreads recipie (if you want to call it that) is now on-line. http://jeremy.zawodny.com/blog/archives/000458.html (I've had several requests for it recently.) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 4 days, processed 141,294,688 queries (327/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
