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
RE: Using more than one CPU on FreeBSD?
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
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 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
Using more than one CPU on FreeBSD?
Hi, I've inherited a FreeBSD/MySQL database-server (Compaq DL360, dual P3 1GHz), running (at the moment): Server version: 4.0.3-beta However, as far as I can tell, MySQL/FreeBSD 4.6.2-RELEASE still can't agree on utilizing more than one CPU. My question is this: A year or two ago, someone mentioned simply running two mysqld's on the same database-files (using file-locking) and then, using some form for loadbalancing between the two, was able to use more than one CPU for the mysqlds. Is this still the recommended way of doing this? I know I could use Linuxthreads, but the times I've tried them in the past, they have done more harm than good (low performance, unstability etc). Any advice would be appreciated :) Kind regards, Tommy Eriksen - 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
RE: backing up
Hi, is there a way to remotely grab the databases (ie mysqldump) and have it place everything in a different file for every database? or has anyone written a script to do something like this? There's propably a more refined way to do this, but this simple hack should do the trick. (Substitute HOST, USER and PASS with values matching your site): --start backup.sh-- #!/bin/sh for i in `echo show databases|mysql -s -hHOST -uUSER -pPASS` do mysqldump -hHOST -uUSER -pPASS --opt $i $i.sql done --end backup.sh-- -- Med venlig hilsen / Kind regards, Tommy Eriksen Systemadministrator, ModuleWEB.NET http://www.modulweb.dk/ - [EMAIL PROTECTED] +45 70 22 33 04 - +45 70 22 33 08 (direct) - 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