Question about threads [beaver challenge]

[Craig Rodrigues]

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 at crodrigues.org