From owner-freebsd-smp Wed Jan 10 6:38:48 2001 Delivered-To: freebsd-smp@freebsd.org Received: from ns.uninet.ee (ns.uninet.ee [194.204.0.1]) by hub.freebsd.org (Postfix) with ESMTP id CFA4837B401; Wed, 10 Jan 2001 06:38:29 -0800 (PST) Received: from inspiral.net (tigris-isdn-64.uninet.ee [194.204.61.64]) by ns.uninet.ee (Postfix) with ESMTP id 5B51325821; Wed, 10 Jan 2001 16:38:02 +0200 (EET) Message-ID: <3A5C7393.40EB4D13@inspiral.net> Date: Wed, 10 Jan 2001 16:37:08 +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, databases@freebsd.org, smp@freebsd.org Subject: mysql (smp) performance Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------msE5D4CB10671614776A5A48CF" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org This is a cryptographically signed message in MIME format. --------------msE5D4CB10671614776A5A48CF 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. --------------msE5D4CB10671614776A5A48CF 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 BTEPFw0wMTAxMTAxNDM3MDlaMCMGCSqGSIb3DQEJBDEWBBToUrsPrMIF0lzrPZjuFm9Z/Rfb 5jBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDAHBgUrDgMC BzANBggqhkiG9w0DAgIBQDANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgHqkaQwu 2IeHb/w5En2Smf1I9GfgOx1Z/LXd1+Oig5Tcx0uqa29sADfVDPJC1KapXTsjHq/a7BGHawgq vklM7YkU8PgDOMhPa/bfK6BSIKvGINJ5K55B9fEjArNLffIon08e85EwD0o+n8VnNjsGSqeY R1cSytU+eTMWKLs2TLwV --------------msE5D4CB10671614776A5A48CF-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message