On Fri, Oct 13, 2000 at 10:17:58AM -0600, sasha@stripped wrote:
> Ekaterina Ivannikova wrote:
> >
> > I am experiencing repeated hangs of mysqld 3.22.32 on
> > FreeBSD 4.1-RELEASE, mysqld is compiled from the ports with
> > native threads. It starts ok, works for some time and then
> > hangs. Hangs are caused by htdig web indexing software
> > accessing mysql thru apache php3.0.16 module. They are
> > absolutely repeatable, it just takes mysql different time to
> > hang.
> >
> > Release: mysql-3.22.32 (Source distribution)
> >
>
> Tim, who is our FreeBSD guy, might be able to offer some
> additional words of advice - any comments, Tim?
Unfortunately, I don't have any more advice than what Monty has
recommended - try 3.23, and if the bug is still there, we'll have
more information available for tracking it down. A LOT of bugs
have been fixed in 3.23 that couldn't be fixed in 3.22, so it is
quite likely that the problem will not show up with the new
version.
Here is how I configure MySQL 3.23 on FreeBSD 4-STABLE (this builds
a debugging version):
#!/bin/sh
export CC CFLAGS CXX CXXFLAGS
CC=cc
CXX=cc
CFLAGS="-Wall -pipe"
CXXFLAGS="-Wall -pipe -fno-rtti -fno-exceptions -felide-constructors"
all=
nono=
while [ $# -gt 0 ]; do
case $1 in
-a ) all=1 ;;
-n ) nono=1 ;;
-* ) echo "unrecognized option: $1" >&2 ;;
esac
shift
done
[ -e sql/mysqld.cc ] || { echo "must be in top level directory" >&2; exit 1; }
if [ "$all" ]; then
cmd="rm -f config.cache && aclocal && autoheader && automake
&& aclocal && autoconf"
if [ "$nono" ]; then
echo "$cmd"
else
eval "$cmd"
fi
fi
cmd="./configure --prefix=/usr/local/mysql \
--with-debug=full \
--without-docs \
--enable-assembler \
--enable-thread-safe-client"
if [ "$nono" ]; then
echo "$cmd"
else
eval "$cmd"
fi
exit 0
Tim
--
Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.
