List:General Discussion« Previous MessageNext Message »
From:Tommy F. Eriksen Date:January 15 2003 8:23am
Subject:RE: Using more than one CPU on FreeBSD?
View as plain text  
Okay.
By the way, sorry about sending you the reply directly before.
However, I've run into a new problem new. Tried to compile mysql-4.0.9 with
linuxthreads-2.2.3_9 (the most recent from ports).
Linuxthreads was installed from ports - and for MySQL I used the following
configure-string:

CFLAGS="-D__USE_UNIX98 -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads \
-felide-constructors -fno-rtti -fno-exceptions" \
./configure --localstatedir=/var/db/mysql --without-perl --without-debug \
--without-readline --without-bench --with-mit-threads=no --with-libwrap \
--program-prefix= --with-innodb --enable-assembler --prefix=/usr/local \
--with-named-thread-libs="-L/usr/local/lib -llthread -llgcc_r"

When doing this, it configures and builds nicely, but when I try to start the
mysql-server, nothing much happens:
-bash-2.05b# /usr/local/share/mysql/mysql.server start
-bash-2.05b# Starting mysqld daemon with databases from /var/db/mysql
030115 08:20:35  mysqld ended

-And in the hostname.err-file I get:

030115 08:20:35  mysqld started
InnoDB: Error: trx_t size is 396 in ha_innodb.cc but 416 in srv0start.c
InnoDB: Check that pthread_mutex_t is defined in the same way in these
InnoDB: compilation modules. Cannot continue.
030115  8:20:35  Can't init databases
030115 08:20:35  mysqld ended

Any ideas? :)

Thanks,
Tommy

> -----Original Message-----
> From: Varshavchick Alexander [mailto:alex@stripped]
> Sent: Wednesday, January 15, 2003 8:51 AM
> To: Tommy F. Eriksen
> Subject: RE: Using more than one CPU on FreeBSD?
> 
> 
> Yes, linuxthreads work superbly with mysql4, which in 
> conjunction with the
> query cache improves performance quite a lot.
> 
> ----
> Alexander Varshavchick, Metrocom Joint Stock Company
> Phone: (812)118-3322, 118-3115(fax)
> 
> On Wed, 15 Jan 2003, Tommy F. Eriksen wrote:
> 
> > Date: Wed, 15 Jan 2003 08:47:05 +0100
> > From: Tommy F. Eriksen <tommy@stripped>
> > To: Varshavchick Alexander <alex@stripped>
> > Subject: RE: Using more than one CPU on FreeBSD?
> >
> > > Hi,
> > >
> > > First of all, we can presume you're using SMP kernel. 
> Then I'd suggest
> > > using Linuxthreads despite your dislike for them - by my
> > > experience, they
> > > work far better for mysql/FreeBSD than native threads. May be
> > > you try it
> > > again - compile mysql from the ports 
> (WITH_LINUXTHREADS=yes), and it
> > > should solve it.
> >
> > Okay, it's been a while since I last tested them, so my 
> info seems to be outdated ;)
> > Do they work as well with mysql4? (We're currently using mysql4 and
> > are quite fond of the query cache and the likes).
> >
> > Thanks,
> > /Tommy
> >
> 
> 
Thread
Using more than one CPU on FreeBSD?Tommy F. Eriksen15 Jan
RE: Using more than one CPU on FreeBSD?Tommy F. Eriksen15 Jan
  • RE: Using more than one CPU on FreeBSD?Varshavchick Alexander15 Jan
RE: Using more than one CPU on FreeBSD?Tommy F. Eriksen15 Jan