>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