Date: Sun, 30 Dec 2007 15:11:18 +0100 From: Gergely CZUCZY <phoemix@harmless.hu> To: Kris Kennaway <kris@FreeBSD.org> Cc: Jeff Roberson <jroberson@chesapeake.net>, freebsd-performance@freebsd.org Subject: Re: mysql scaling questions Message-ID: <20071230141118.GA67574@harmless.hu> In-Reply-To: <4777A65C.8020406@FreeBSD.org> References: <20071201205609.GA54238@harmless.hu> <200712012108.lB1L8qAd005766@lava.sentex.ca> <20071201211012.GA55519@harmless.hu> <20071201122122.S884@192.168.1.107> <20071204130810.GA77186@harmless.hu> <47779AA7.2060801@FreeBSD.org> <20071230132451.GA61295@harmless.hu> <47779EBC.5020900@FreeBSD.org> <20071230134354.GA63555@harmless.hu> <4777A65C.8020406@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--azLHFNyN32YCQGCU Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Dec 30, 2007 at 03:08:28PM +0100, Kris Kennaway wrote: > Gergely CZUCZY wrote: > >On Sun, Dec 30, 2007 at 02:35:56PM +0100, Kris Kennaway wrote: > >>Gergely CZUCZY wrote: > >> > >>>>I appreciate that you might be constrained by local requirements, but= it's really not meaningful to compare different mysql=20 > >>>>versions if your goal is to study OS performance. > >>>It'd be a PITA to install the both versions. Maybe now, that the ports= freeze is over, i can > >>>do something. But honestly, every mysql version was faster on linux, t= han eny on FreeBSD, > >>>even the .22 one was faster. We start work on Jan02, I will see what c= an I do. > >>Regardless, we need a stable baseline to compare to. > >Cannot do it sooner then january. Any recommended versions? >=20 > Either 5.0.45 on both, or 5.0.51 on both, please. Ack. > >>Still waiting for your sysbench command lines :) > >There were 2 scripts and a sources file with options: > >basicall that's everything. I know it's a but complex, but this was all = behind it. >=20 > OK, that was very important since you're changing defaults. For different configurations, yes. But every test is heterogenous. >=20 > It looks like myisam is doing huge numbers of concurrent reads of the sam= e file which is running into exclusive locking in the kernel=20 > (vnode interlock and lockbuilder mtxpool). Does it not do any caching of= the data in userspace but relies on querying into the kernel=20 > every time? innodb doesn't have this behaviour. Sorry, but was this a rethorical kind of question, or was this addressed to= me? :) If the later, then how do I find this out? Sincerely, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --azLHFNyN32YCQGCU Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) owGFVU1vG1UUDa0AaRCLrpCgi7tBoao9OE7dGiM7bZO2mKhqRYIqUjbPM9f2wzPv Td57E2e6Y9cFqoAlSGXBAjaID7FH/AGW/Ad+BZw74yQVUtWNlby5H+fcc+57X75+ fu3chb9++f3h5S++/valn179fHI5L0Mws3au3JE27Y1OZ6N99Vrv2pX21fbmZpqy 6vevbL7X3ex1O3eWP7yybU1gE9r7VcEDCnwc3i0ypc37lMyV8xyGZZi2+9FJ3I72 hfU6aGsGpE2mDZ9+23fK+Cm79i2T2FSb2YAOSxs4bRdOm6AmGUfRPUN7pWnRDie0 2WlRt9O5RipQZ3PQ6Q+6/ft36XIHsFu067SnXTZGLVVFS4dKg2hEd9jNOKto++Dj 7YNPzs5Hz63cHWz2Br2rL6w8Gj239qj+GY3GpIrCcaJVYApzVK9sSbmezQNNmBJr fHAYH6c0qSizicrI8WGpHecYkW/RpAzDiHRY9/igMjQzNlDOymBg0zKjYFEmL5Rj SvUU40Qe5ZU/zIbdzgrGETsPBTzpqQBwNLNoBFJI9qFMK7q3RwW7qXW5MgnHTd44 rKcCU9H98f4NCdbACxCgwjSxYU4nlWO6qyqEGrtsNUQlpLAueMCfOuZHLA0tElqk KVGm6ZECgc05zEEnpptloLk17ENWtYgRXDVcThrRUnmaKh/YEf6Dn8pjNBxGc2WI TSWHt9Ht5t5Oq2mAIqYGE3e7+MrPVIjpAYO/coGW1i0k90NlOt0WjWmpQdMzwoVM MoxQf0ypbUbzEc+USzP2UGgJ1gwBlZSCZ2miPIvRn5UmNInbyoh8IK0DeAOOE2yG PlOmVK6K6QY4wDA2h/4pqp4MeCsaNXre0khw1Is78ZWeQBYdWmSbo97G2VGRMZDE 0Y1kEUc17L0grJYK+2hmBLUbN/jKT9gkc0EL/VMZK3saXJKkfXTDFOSnSz5xugie JAh8kZwgcKrBeglcZAvZdF/vAMagk8YsSuxbq7nSeUwLOKWxtRKP14PK+Lg2PDJg FdFJ0ofRhJGVIjo+GcK93ZXLJKh2ic7FbAre9xoOFmLrgIxbycyEbMpTVWbBx9Ft 0D7bFKzgVM9Kp2rgLarYNzZszBdgRfHtnOEXO2NjS3+KYhywsnbhMa8Fw6faq1yC Uysd5+UMzijzCRQkO5VOSenqptjktD4TXyJpGPFqiHMNGVDClUYWHAsHE/FxkpVe H7HcEIvmuE5dsDO82vN3joxNWRLYSVitkfwxKXWWwjF5OC6szS7FRDsWqsGBKy8q eC5RiUgDUNhXqZ2qoKRP6YG/UBipKOPgbOTCY4cl5nMK8f9oVtPTOW8hAMgmaMTe rGO/1RE3CkNXdaRhojjas85Vjfgiaf1ZoVuYWycuooU4ABNDWy9S1Y4/C01Th2XE vgQL/NIV7h03A85w+bpWs2dzuA6Mxxg36tW5tgxbUbQnrgG7qhVFp9f6ozJ5VEW5 0lmwA5o1x3FSH1/He5fLDRDPyyhqt4X3A2Yj4xHXxHh5jMb0PPYkA+XCWdwOuW+M q/CmYDcfb51/eU0e1pNX+cK53SdrT/vfP/7g4ZPe6NO//7l08OebG9/c/PHXte/s 9d+2X/v57aeji/2D+Ks/3li7+Na//wE= =kTBy -----END PGP SIGNATURE----- --azLHFNyN32YCQGCU--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071230141118.GA67574>