Date: Tue, 10 Feb 2004 17:11:24 -0500 From: Craig Rodrigues <rodrigc@crodrigues.org> To: Kris Gale <kris-fbsd@asn.net> Cc: freebsd-threads@freebsd.org Subject: Re: Question about threads [beaver challenge] Message-ID: <20040210221124.GA48300@crodrigues.org> In-Reply-To: <53224.68.3.131.72.1076449765.squirrel@mail.asn.net> References: <1076398781.b793f9a0dkt@digitalme.com> <51993.68.3.131.72.1076432061.squirrel@mail.asn.net> <20040210193240.GA47392@crodrigues.org> <53224.68.3.131.72.1076449765.squirrel@mail.asn.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, Feb 10, 2004 at 02:49:25PM -0700, Kris Gale wrote: > MySQL 4.0.17 from ports. KSE entries in libmap.conf. > > I tried it with and without BUILD_OPTIMIZED. I did not BUILD_STATIC, > as I normally do. The DB_DIR was reconfigured. > > > How big were the tables that you used? > > The database powers a complicated web application. There are about > 150 tables. Some have a few rows, some have hundreds of thousands > of rows. > > > How many queries did you hit the database with? > > ---[ From previous thread]--- > The first time I tried it, we were maintaining a load of about 600 > threads and 300 queries/second and lasted about three hours > before the thread count went through the roof and MySQL became > unresponsive. > > The second time, we were sustaining a load of 1300 threads and > 600 queries/second. This only lasted about 30 minutes. > ------ OK, this is good information to start off with. Is there a representative test application which comes with MySQL that could be used to hammer on the FreeBSD KSE implementation? I see many MySQL mailing lists at: http://lists.mysql.com.....is there a mailing list there which is appropriate to ask about threading issues, such as MySQL Internals? I think certain applications like MySQL and Apache should be of high priority to get working nicely with FreeBSD KSE before 5.3. -- Craig Rodrigues http://crodrigues.org rodrigc@crodrigues.org
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040210221124.GA48300>