From: sasha
Date: October 20 2000 4:27pm
Subject: Re: mysql still hangs on FreeBSD 4.1 (long)
List-Archive: http://lists.mysql.com/bugs/457
Message-Id: <39F07259.66BFDEA2@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Ekaterina Ivannikova wrote:
> 
> Hi,
> 
> thanks for your input.
> 
> > This does look like some really strange thread library problem. Can you try the
> > following:
> >  * link statically
> 
> This did not help.
> 
> >  * update your libc
> 
> It seems that libc_r was last updated in April, so mine should be up to date.
> 
> > if the above does not help, can you write a program that can be run outside of
> > the context of your system that will hang mysqld on your system?
> 
> The problem is, the hangs occur in different places. They are caused by web
> indexing software (htdig) which accesses mysqld thru apache mod_php (3.0.17)
> compiled with mysql support. Since it runs on the same host, it just probably
> overloads mysql (or the thread lib ?). So a web site making intensive use of
> mysql database + htdig would be the appropriate setup for testing.
> Anyway, I posted a question to freebsd-bugs and will inform the list of the
> results.

In this case, you should be able to duplicate the problem using
mysql-super-smack ( see http://www.mysql.com/Contrib/mysql-bench-0.6.tar.gz ) -
you may need a bit of playing around to find the right combination of queries,
though.

-- 
MySQL Development Team
   __  ___     ___ ____  __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <sasha@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
       <___/