>From ports?
This may be a dumb question, but where in the ports tree does mysql4 reside?
If I look in /usr/ports/databases, I see a lot of mysql-utilities (mysqltcl etc), 
mysql323-server & 323-client - but no mysql4?

Thanks,
Tommy

> -----Original Message-----
> From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 15, 2003 11:24 AM
> To: Tommy F. Eriksen
> Cc: [EMAIL PROTECTED]
> Subject: RE: Using more than one CPU on FreeBSD?
> 
> 
> Did you try installing mysql4 also from ports? I didn't try 4.0.9 but
> 4.0.4 builded nicely this way for me.
> 
> ----
> 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 09:23:18 +0100
> > From: Tommy F. Eriksen <[EMAIL PROTECTED]>
> > To: Varshavchick Alexander <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: Using more than one CPU on FreeBSD?
> >
> > 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:[EMAIL PROTECTED]]
> > > 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 <[EMAIL PROTECTED]>
> > > > To: Varshavchick Alexander <[EMAIL PROTECTED]>
> > > > 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
> > > >
> > >
> > >
> >
> > 
> ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: 
http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to