From owner-freebsd-database Sun Jan 7 3: 7:50 2001 Delivered-To: freebsd-database@freebsd.org Received: from smtp4.libero.it (smtp4.libero.it [193.70.192.54]) by hub.freebsd.org (Postfix) with ESMTP id 49E1D37B402 for ; Sun, 7 Jan 2001 03:07:33 -0800 (PST) Received: from parkinson.it (151.20.60.110) by smtp4.libero.it (5.5.015.5) id 3A54738F001E3957 for freebsd-database@freebsd.org; Sun, 7 Jan 2001 12:07:31 +0100 Message-ID: <3A584DF2.32A69D78@parkinson.it> Date: Sun, 07 Jan 2001 12:07:30 +0100 From: Gianluca Sordiglioni X-Mailer: Mozilla 4.72 [en] (X11; I; FreeBSD 4.2-STABLE i386) X-Accept-Language: it, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Subject: Postgresql compile error Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Trying to compile postgresql7 on FreeBSD 4.2 with different options I always get this error: gmake[2]: Entering directory `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/perl5' gmake[2]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/perl5' gmake -C odbc all gmake[2]: Entering directory `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/odbc' cc -I../../include -I../../backend -I/usr/local/include -I/usr/local/include/tcl8.3 -I/usr/local/include/tk8.3 -O -pipe -march=pentiumpro -DUSE_SSL -I. -DHAVE_CONFIG_H -fpic -DPIC -c -o tuplelist.o tuplelist.c In file included from tuplelist.c:16: /usr/local/include/malloc.h:81: syntax error before `*' /usr/local/include/malloc.h:82: syntax error before `*' /usr/local/include/malloc.h:87: syntax error before `*' gmake[2]: *** [tuplelist.o] Error 1 gmake[2]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/odbc' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces' gmake: *** [all] Error 2 *** Error code 2 Stop in /usr/ports/databases/postgresql7. Okay, so I edited tuplelist.c and commented out #include : the result is it compiles, but won't start. I took a look to malloc.h, seems ok. Any idea? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Jan 9 17: 6:39 2001 Delivered-To: freebsd-database@freebsd.org Received: from cards2talk.com (unknown [216.199.94.59]) by hub.freebsd.org (Postfix) with ESMTP id 8AF0037B400; Tue, 9 Jan 2001 17:06:19 -0800 (PST) Received: from localhost (mikes@localhost) by cards2talk.com (8.11.1/8.11.1) with ESMTP id f09K86T79366; Tue, 9 Jan 2001 20:08:06 GMT (envelope-from mikes@OpenBSDbox.com) Date: Tue, 9 Jan 2001 20:08:05 +0000 (GMT) From: msstein X-Sender: mikes@cards2talk.com To: database@freebsd.org Cc: questions@freebsd.org Subject: ESQL/C NATIVE port to FreeBSD 4.x wahoo :-) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG It all started 12 months ago when I was working for a telcom that had many informix databases. They wanted me to write some CGI's to generate those lovely graphical statistical reports that all management loves to see. The problem was trying to find a port of Informix's esql/c compiler and libraries was impossible. It did'nt exist. Well, a year later I am working for a new company and I needed the same thing. IN order to get perl or php to work with informix DB's you need to have esql/c/ I tried running the linux binaries under FreeBSD's linux emulation but .. that was'nt bringing me much success. For the hell of it, I asked someone in #openbsd on efnet and they pointed me to a slashdot article about an informix employee asking if they should develop a port to freebsd or not. It was dated 7 months or so ago .. but I did'nt care I emailed her anyway .. would'nt you know .. she did'nt work in that dept anymore ..but gave me directions .. after 2 weeks of calling 100's of numbers talking to many informix tech's and DBA's I finally found what I was looking for ... and no, you cannot d/l it from intraware.com because informix no longer has a contract with them .. but if you want a CD with CLientSDK2.5 FOr FreeBSD 4.0 and up .. well all you have to do is call informix customer service :) ... which even they don't know it exists .. it took me 3 or 4 people before someone found the info I needed .... so, if you are like me, and have been using linux just to run your php and perl scripts to connect to a remote informix database ... have no fear because the port is available .. I am not sure if anyone has had this dilemna .. but I would'nt think I was the only one ... there is a reference # to the FreeBSD version specifically .. so if you are interested .. go ahead and email me .. and I will give you the reference # and it will make your life a hell of a lot easier .. when searching for this port. I have yet to be let down .. when it comes to running FreeBSD over Linux in regards to the so called amount of linux ported software vs freebsd .. I am still and will always remain dedicated :-) Home is where the heart is .. you can email me at mikes at openbsdbox.com ( spelled out so no filters would hide my address from you like geocrawler does.) anyway ... thanks to the informix people .. and the freebsd folk as well .. --mike To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 6:41: 9 2001 Delivered-To: freebsd-database@freebsd.org Received: from ns.uninet.ee (ns.uninet.ee [194.204.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 55CBC37B401 for ; Wed, 10 Jan 2001 06:40:50 -0800 (PST) Received: from inspiral.net (tigris-isdn-64.uninet.ee [194.204.61.64]) by ns.uninet.ee (Postfix) with ESMTP id 777CC25AC4 for ; Wed, 10 Jan 2001 16:40:24 +0200 (EET) Message-ID: <3A5C742A.620F9B00@inspiral.net> Date: Wed, 10 Jan 2001 16:39:38 +0200 From: Lauri Laupmaa Organization: Inspiral.Net X-Mailer: Mozilla 4.76 [en] (Win98; U) X-Accept-Language: en,et MIME-Version: 1.0 To: database@freebsd.org Subject: mysql (smp) performance Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms5EE6B915468755E3D4D763F9" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG This is a cryptographically signed message in MIME format. --------------ms5EE6B915468755E3D4D763F9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi After some fair amount of testing I came to conclusion that unfortunately mysql (both 3.22 and 3.23) performance is considerably slower on freebsd than linux...at least on stock install. I have used 4.x-STABLE systems, both on SMP and singleproc and linux 2.1/2.2 kernels. It seems that on SMP mysql doesn't scale well. (currently testing on dual 833 PIII and running on couple older dual systems) I'm interested if there is some magic to get mysql run faster ? Or should I use 5.x-CURRENT ? TIA L. --------------ms5EE6B915468755E3D4D763F9 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIKKwYJKoZIhvcNAQcCoIIKHDCCChgCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC B7cwggSBMIID6qADAgECAhBRff1uOxqNtD+DymrDYl03MA0GCSqGSIb3DQEBBAUAMIHMMRcw FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5 IFJlZi4sTElBQi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRp dmlkdWFsIFN1YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMB4XDTAxMDEwNzAwMDAw MFoXDTAxMDMwODIzNTk1OVowggEFMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UE CxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9y ZXBvc2l0b3J5L1JQQSBJbmNvcnAuIGJ5IFJlZi4sTElBQi5MVEQoYyk5ODEeMBwGA1UECxMV UGVyc29uYSBOb3QgVmFsaWRhdGVkMSYwJAYDVQQLEx1EaWdpdGFsIElEIENsYXNzIDEgLSBO ZXRzY2FwZTEWMBQGA1UEAxQNTGF1cmkgTGF1cG1hYTEhMB8GCSqGSIb3DQEJARYSbWF1cmlA aW5zcGlyYWwubmV0MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCtwtrfGV1XM4dhgowq QK9fsL+Ip5UthKacaoNORgLX6nxAOXUeLPePFHrUjCVtYRbfrAjCPmE5Zy9Qnpfm4fgf/sK2 5IQ+QoHdY/g6BZ+7dc9Wf3ZszKrw/NT/Wu8Mmvg7Ek34F460CHxgCVxRYPMYt+gK7Ly8ubGE /zXHfMzNYQIDAQABo4IBJjCCASIwCQYDVR0TBAIwADBEBgNVHSAEPTA7MDkGC2CGSAGG+EUB BwEIMCowKAYIKwYBBQUHAgEWHGh0dHBzOi8vd3d3LnZlcmlzaWduLmNvbS9ycGEwEQYJYIZI AYb4QgEBBAQDAgeAMIGGBgpghkgBhvhFAQYDBHgWdmQ0NjUyYmQ2M2YyMDQ3MDI5Mjk4NzYz YzlkMmYyNzUwNjljNzM1OWJlZDFiMDU5ZGE3NWJjNGJjOTcwMTc0N2RhNWQzZjQxNDFiZWFk YjJiZDJlODkyMTZhZDZiZjFkNzExNDk5Y2EyYjk0NWZkZjNlYTQ1MGQwMwYDVR0fBCwwKjAo oCagJIYiaHR0cDovL2NybC52ZXJpc2lnbi5jb20vY2xhc3MxLmNybDANBgkqhkiG9w0BAQQF AAOBgQBcAPAx7vFJmoiGWujs15eHChQjeK/95q6UT+wXqfJ1sa0DUZdipBYq4MANkN2Bcauh J0L22WU64bMsD8K4yPEEf7XEXfOlsn0XEWwWI819pbEnUrDnc4z/D4wbnQwf85v2mHtfw+kD EUR+A4zomDnKek1ZHdjt7WBbLStYoTnVvzCCAy4wggKXoAMCAQICEQDSdi6NFAw9fbKoJV2v 7g11MA0GCSqGSIb3DQEBAgUAMF8xCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5WZXJpU2lnbiwg SW5jLjE3MDUGA1UECxMuQ2xhc3MgMSBQdWJsaWMgUHJpbWFyeSBDZXJ0aWZpY2F0aW9uIEF1 dGhvcml0eTAeFw05ODA1MTIwMDAwMDBaFw0wODA1MTIyMzU5NTlaMIHMMRcwFQYDVQQKEw5W ZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UE CxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJlZi4sTElB Qi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFsIFN1 YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCB iQKBgQC7WkSKBBa7Vf0DeootlE8VeDa4DUqyb5xUv7zodyqdufBou5XZMUFweoFLuUgTVi3H COGEQqvAopKrRFyqQvCCDgLpL/vCO7u+yScKXbawNkIztW5UiE+HSr8Z2vkV6A+HthzjzMaa jn9qJJLj/OBluqexfu/J2zdqyErICQbkmQIDAQABo3wwejARBglghkgBhvhCAQEEBAMCAQYw RwYDVR0gBEAwPjA8BgtghkgBhvhFAQcBATAtMCsGCCsGAQUFBwIBFh93d3cudmVyaXNpZ24u Y29tL3JlcG9zaXRvcnkvUlBBMA8GA1UdEwQIMAYBAf8CAQAwCwYDVR0PBAQDAgEGMA0GCSqG SIb3DQEBAgUAA4GBAIi4Nzvd2pQ3AK2qn+GBAXEekmptL/bxndPKZDjcG5gMB4ZbhRVqD7lJ haSV8Rd9Z7R/LSzdmkKewz60jqrlCwbe8lYq+jPHvhnXU0zDvcjjF7WkSUJj7MKmFw9dWBpJ PJBcVaNlIAD9GCDlX4KmsaiSxVhqwY0DPOvDzQWikK5uMYICPDCCAjgCAQEwgeEwgcwxFzAV BgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3Jr MUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkg UmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAxIENBIEluZGl2 aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0ZWQCEFF9/W47Go20P4PKasNi XTcwCQYFKw4DAhoFAKCBsTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJ BTEPFw0wMTAxMTAxNDM5MzlaMCMGCSqGSIb3DQEJBDEWBBRB0MBNlMA5UnAeh+QOX5/p2U1T wDBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDAHBgUrDgMC BzANBggqhkiG9w0DAgIBQDANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgDhio30b ewtSQR9fQOIVtuNckUmA5NsPcZeiIaPpPp7cK1iyVQlzxVlEZYKeLRvn2UbhXhDiPbpHnTRW dV5+47emSdypMgD5d/VrtVnyFcBcncjWkF3nxLpwh7l2v4mrBUi/UHcWuscn4TBDpJGSOEHB 0iso2pY9V5qyuJmwN0qU --------------ms5EE6B915468755E3D4D763F9-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 9: 9:58 2001 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id CC21437B401 for ; Wed, 10 Jan 2001 09:09:35 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 14GO2q-0006X3-00; Wed, 10 Jan 2001 08:24:16 -0800 Date: Wed, 10 Jan 2001 08:24:04 -0800 (PST) From: Tom Samplonius To: Lauri Laupmaa Cc: database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: <3A5C742A.620F9B00@inspiral.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII Content-ID: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 10 Jan 2001, Lauri Laupmaa wrote: ... > It seems that on SMP mysql doesn't scale well. (currently testing on > dual 833 PIII and running on couple older dual systems) Because there is no such thing as SMP mysql. It is a single process, and can only run on a single processor at a time. > I'm interested if there is some magic to get mysql run faster ? > Or should I use 5.x-CURRENT ? You can run multiple instances of mysql. You may want to do this anyways, if you are using mysql in a hosting environment. > TIA > > L. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 9:16: 3 2001 Delivered-To: freebsd-database@freebsd.org Received: from picalon.gun.de (picalon.gun.de [192.109.159.1]) by hub.freebsd.org (Postfix) with ESMTP id 5AAA037B401; Wed, 10 Jan 2001 09:15:28 -0800 (PST) Received: (from uucp@localhost) by picalon.gun.de (8.9.3/8.9.3) id SAA26032; Wed, 10 Jan 2001 18:15:17 +0100 (MET) >Received: (from andreas@localhost) by klemm.gtn.com (8.11.1/8.11.1) id f0AH5Hh03786; Wed, 10 Jan 2001 18:05:17 +0100 (CET) (envelope-from andreas) Date: Wed, 10 Jan 2001 18:05:17 +0100 From: Andreas Klemm To: Lauri Laupmaa Cc: database@freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110180517.A3741@titan.klemm.gtn.com> References: <3A5C7393.40EB4D13@inspiral.net> Mime-Version: 1.0 Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A5C7393.40EB4D13@inspiral.net>; from mauri@inspiral.net on Wed, Jan 10, 2001 at 04:37:08PM +0200 X-Operating-System: FreeBSD 4.2-STABLE SMP X-Disclaimer: A free society is one where it is safe to be unpopular Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I found another interesting link for FreeBSD && mysql: http://www.bitmechanic.com/mail-archives/mysql/Nov1997/0425.html +------------------------------------------------------------------- > I've just got a brand new 200Mhz Pentium machine with two 4 gig SCSI > disks for me to use. Its only purpose in life is to be a mysql > server. I want this baby to scream. I'm planning on ccd-ing the two > disks together to get the benefits of having two spindles. What else > should I do? Does anyone have experience and advice with opening up > the server configuration options, like buffers and open files, etc? > > Thanks, > > Nat You want to rebuild a kernel with the following options maxusers 256 options CHILD_MAX=512 options OPEN_MAX=256 # this is with 256 MB RAM adjust these figures based on # how much RAM you have options "MAXDSIZE=(256*1024*1024)" options "DFLDSIZE=(128*1024*1024)" # set this otherwise the kernel only recognizes the first 64 MB options MAXMEM=262144 # 256 MB options NMBCLUSTERS=4096 options COPTFLAGS="-O2 -fexpensive-optimizations -m486 -fomit-frame-pointer" +------------------------------------------------------------------- Note: concerning COPTFLAGS, be careful ... -pipe -O is know to produce the "correctest" code.... First I'd try the other options. Be careful with the settings, if you don't have enough RAM ... Andreas /// -- Andreas Klemm - Powered by FreeBSD 4.2 SMP Need a magic printfilter today ? -> http://www.apsfilter.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 9:15:59 2001 Delivered-To: freebsd-database@freebsd.org Received: from picalon.gun.de (picalon.gun.de [192.109.159.1]) by hub.freebsd.org (Postfix) with ESMTP id 44B9937B400; Wed, 10 Jan 2001 09:15:28 -0800 (PST) Received: (from uucp@localhost) by picalon.gun.de (8.9.3/8.9.3) id SAA26023; Wed, 10 Jan 2001 18:15:16 +0100 (MET) >Received: (from andreas@localhost) by klemm.gtn.com (8.11.1/8.11.1) id f0AH1ev03728; Wed, 10 Jan 2001 18:01:41 +0100 (CET) (envelope-from andreas) Date: Wed, 10 Jan 2001 18:01:40 +0100 From: Andreas Klemm To: Lauri Laupmaa Cc: database@freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110180139.A3584@titan.klemm.gtn.com> References: <3A5C7393.40EB4D13@inspiral.net> Mime-Version: 1.0 Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A5C7393.40EB4D13@inspiral.net>; from mauri@inspiral.net on Wed, Jan 10, 2001 at 04:37:08PM +0200 X-Operating-System: FreeBSD 4.2-STABLE SMP X-Disclaimer: A free society is one where it is safe to be unpopular Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, Jan 10, 2001 at 04:37:08PM +0200, Lauri Laupmaa wrote: > I have used 4.x-STABLE systems, both on SMP and singleproc and linux > 2.1/2.2 kernels. Which kernel profile ? GENERIC ? Modified ? Ralf Engelschall wrote a paper how to fine tune FreeBSD kernel for high performance load sharing webservers ... Certainly there are things that could be tuned when using databases. Did you already ask on the mysql mailinglist, what they recommend to fine tune to increase performance in general for mysql ? Perhaps they already have some experience with FreeBSD ? Already searched the archives (www.google.com) ? I looked for: mysql performance tuning And got some links: http://www.tryc.on.ca/archives/mysql/December1999/0009.html What disks are you using SCSI or IDE ? What driver settings in the kernel ... Some kernel options might give a difference. Maybe the Linux machines have some performance knobs turned on, in certain areas FreeBSD is more restrictive in turning on such knobs per default, with the sake to support more (crappy) hardware. Andreas /// -- Andreas Klemm - Powered by FreeBSD 4.2 SMP Need a magic printfilter today ? -> http://www.apsfilter.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 9:39:49 2001 Delivered-To: freebsd-database@freebsd.org Received: from search.sparks.net (search.sparks.net [208.5.188.60]) by hub.freebsd.org (Postfix) with ESMTP id 517BF37B401 for ; Wed, 10 Jan 2001 09:39:32 -0800 (PST) Received: by search.sparks.net (Postfix, from userid 100) id EE32FDB23; Wed, 10 Jan 2001 12:38:39 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id DD9B2DB22; Wed, 10 Jan 2001 12:38:39 -0500 (EST) Date: Wed, 10 Jan 2001 12:38:39 -0500 (EST) From: David Miller To: Tom Samplonius Cc: Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 10 Jan 2001, Tom Samplonius wrote: > > On Wed, 10 Jan 2001, Lauri Laupmaa wrote: > > ... > > It seems that on SMP mysql doesn't scale well. (currently testing on > > dual 833 PIII and running on couple older dual systems) > > Because there is no such thing as SMP mysql. It is a single process, > and can only run on a single processor at a time. My understanding is that it's single process but multithreaded. When I asked a very similar question on a mysql list a year ago I was told that on linux it ran much better on multiple cpu's. --- David To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 10:20:15 2001 Delivered-To: freebsd-database@freebsd.org Received: from server.bitmcnit.bryansk.su (bitmcnit.bryansk.ru [195.239.213.9]) by hub.freebsd.org (Postfix) with ESMTP id EF93F37B6A2 for ; Wed, 10 Jan 2001 10:18:35 -0800 (PST) Received: (from uucp@localhost) by server.bitmcnit.bryansk.su (8.9.3/8.9.3) with UUCP id VAA25074; Wed, 10 Jan 2001 21:05:23 +0300 Received: (from alex@localhost) by kapran.bitmcnit.bryansk.su (8.11.1/8.11.1) id f0AHsmD01357; Wed, 10 Jan 2001 20:54:48 +0300 (MSK) (envelope-from alex@kapran.bitmcnit.bryansk.su) Date: Wed, 10 Jan 2001 20:54:47 +0300 From: Alex Kapranoff To: Tom Samplonius Cc: Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110205447.A824@kapran.bitmcnit.bryansk.su> References: <3A5C742A.620F9B00@inspiral.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from tom@sdf.com on Wed, Jan 10, 2001 at 08:24:04AM -0800 X-Operating-System: FreeBSD 5.0-CURRENT i386 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, Jan 10, 2001 at 08:24:04AM -0800, Tom Samplonius wrote: > On Wed, 10 Jan 2001, Lauri Laupmaa wrote: > > > It seems that on SMP mysql doesn't scale well. (currently testing on > > dual 833 PIII and running on couple older dual systems) > > Because there is no such thing as SMP mysql. It is a single process, > and can only run on a single processor at a time. MySQL is heavily multithreaded and thus should take advantage of good SMP. -- Alex Kapranoff, Voice: +7(0832)791845 We've lived 236 hours in the brand new millenium... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 10:55:38 2001 Delivered-To: freebsd-database@freebsd.org Received: from search.sparks.net (search.sparks.net [208.5.188.60]) by hub.freebsd.org (Postfix) with ESMTP id 970BB37B400 for ; Wed, 10 Jan 2001 10:55:21 -0800 (PST) Received: by search.sparks.net (Postfix, from userid 100) id 56FACDB25; Wed, 10 Jan 2001 13:54:28 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id 39142DB21; Wed, 10 Jan 2001 13:54:28 -0500 (EST) Date: Wed, 10 Jan 2001 13:54:28 -0500 (EST) From: David Miller To: Alex Kapranoff Cc: Tom Samplonius , Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: <20010110205447.A824@kapran.bitmcnit.bryansk.su> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 10 Jan 2001, Alex Kapranoff wrote: > On Wed, Jan 10, 2001 at 08:24:04AM -0800, Tom Samplonius wrote: > > On Wed, 10 Jan 2001, Lauri Laupmaa wrote: > > > > > It seems that on SMP mysql doesn't scale well. (currently testing on > > > dual 833 PIII and running on couple older dual systems) > > > > Because there is no such thing as SMP mysql. It is a single process, > > and can only run on a single processor at a time. > > MySQL is heavily multithreaded and thus should take advantage of good SMP. Only if it likes the threads of the host, and if the host manages those threads efficiently. I've "heard all around" that this is a poor area for FreeBSD, but would love to hear from someone who can speak with firsthand knowledge about freebsd threads and mysql. Thanks, --- David To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 11:15: 2 2001 Delivered-To: freebsd-database@freebsd.org Received: from mx.nsu.ru (mx.nsu.ru [193.124.215.71]) by hub.freebsd.org (Postfix) with ESMTP id EAD6837B400 for ; Wed, 10 Jan 2001 11:14:42 -0800 (PST) Received: from iclub.nsu.ru (root@iclub.nsu.ru [193.124.222.66]) by mx.nsu.ru (8.9.1/8.9.0) with ESMTP id BAA00917; Thu, 11 Jan 2001 01:13:20 +0600 (NOVT) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id f0AJDID13461; Thu, 11 Jan 2001 01:13:19 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Thu, 11 Jan 2001 01:13:18 +0600 (NS) From: Max Khon To: David Miller Cc: Alex Kapranoff , Tom Samplonius , Lauri Laupmaa , database@FreeBSD.ORG Subject: Re: mysql (smp) performance In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Wed, 10 Jan 2001, David Miller wrote: > > > > It seems that on SMP mysql doesn't scale well. (currently testing on > > > > dual 833 PIII and running on couple older dual systems) > > > > > > Because there is no such thing as SMP mysql. It is a single process, > > > and can only run on a single processor at a time. > > > > MySQL is heavily multithreaded and thus should take advantage of good SMP. > > Only if it likes the threads of the host, and if the host manages those > threads efficiently. I've "heard all around" that this is a poor area for > FreeBSD, but would love to hear from someone who can speak with firsthand > knowledge about freebsd threads and mysql. FreeBSD threads do not spread over CPUs -current will have better SMP and better threads implementation (but AFAIK it is not here yet) /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 20:56:16 2001 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 6B7AB37B401 for ; Wed, 10 Jan 2001 20:55:55 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 14GZ4E-0007T4-00; Wed, 10 Jan 2001 20:10:26 -0800 Date: Wed, 10 Jan 2001 20:10:23 -0800 (PST) From: Tom Samplonius To: David Miller Cc: Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 10 Jan 2001, David Miller wrote: > On Wed, 10 Jan 2001, Tom Samplonius wrote: > > > On Wed, 10 Jan 2001, Lauri Laupmaa wrote: > > > > ... > > > It seems that on SMP mysql doesn't scale well. (currently testing on > > > dual 833 PIII and running on couple older dual systems) > > > > Because there is no such thing as SMP mysql. It is a single process, > > and can only run on a single processor at a time. > > My understanding is that it's single process but multithreaded. When I > asked a very similar question on a mysql list a year ago I was told that > on linux it ran much better on multiple cpu's. You can however compile mysql with linuxthreads. BTW, the linuxthreads is a full FreeBSD port of the linuxthreads package, which provides pseudo-process threads. These threads are scheduled as processes and you will see a performance improvement with SMP. Linux threads are rather heavy weight, so this solution has not been included as the standard thread package. Standard FreeBSD theads are now (as 4.2-stable) solid and reliable. Reliability has been inconsistant. I have a 3.5-STABLE system using mysql and the native threads on a 2 GB database. No problems. Standard FreeBSD threads have less overhead that threads on Linux, or Linux-like threads on FreeBSD. > --- David Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 10 20:58:35 2001 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 2725337B400 for ; Wed, 10 Jan 2001 20:58:18 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 14GZ6G-0007Td-00; Wed, 10 Jan 2001 20:12:32 -0800 Date: Wed, 10 Jan 2001 20:12:30 -0800 (PST) From: Tom Samplonius To: Alex Kapranoff Cc: Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: <20010110205447.A824@kapran.bitmcnit.bryansk.su> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 10 Jan 2001, Alex Kapranoff wrote: > > Because there is no such thing as SMP mysql. It is a single process, > > and can only run on a single processor at a time. > > MySQL is heavily multithreaded and thus should take advantage of good SMP. Well, multiprocessing will take advantage of SMP just as good as multithreading. However, today FreeBSD can't schedule threads belong to a single process on more than one CPU. > -- > Alex Kapranoff, Voice: +7(0832)791845 > We've lived 236 hours in the brand new millenium... Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Jan 12 1:31:34 2001 Delivered-To: freebsd-database@freebsd.org Received: from spiral.inspiral.net (spiral.inspiral.net [194.204.49.249]) by hub.freebsd.org (Postfix) with ESMTP id 09AD237B400 for ; Fri, 12 Jan 2001 01:31:17 -0800 (PST) Received: from localhost (mauri@localhost) by spiral.inspiral.net (8.11.1/8.11.1) with ESMTP id f0C9V8X64546 for ; Fri, 12 Jan 2001 11:31:09 +0200 (EET) (envelope-from mauri@spiral.inspiral.net) Date: Fri, 12 Jan 2001 11:31:08 +0200 (EET) From: Lauri Laupmaa To: Subject: mysql323 & linuxthreads help needed Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi I have linuxthreads port installed... I want to build mysql daemon to use it, but havent had any luck... I have searched mailinglist archives, but did not find a definitive answer. Maybe someone can shed some light on this issue... some ./configure flags would be welcome. ...and Yes, I'm runnings 4.2-STABLE TIA L. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message