Date: Fri, 11 Feb 2005 07:10:25 +0000 From: Antony T Curtis <antony.t.curtis@ntlworld.com> To: Thomas Hurst <tom.hurst@clara.net> Cc: Scott Long <scottl@freebsd.org> Subject: Re: MySQL benchmarks Message-ID: <1108105825.60161.4.camel@pcgem.rdg.cyberkinetica.com> In-Reply-To: <20050210224643.GA47912@voi.aagh.net> References: <20050209205943.34c39e15.flynn@energyhq.es.eu.org> <420A909C.8070701@freebsd.org> <1108071290.59338.8.camel@pcgem.rdg.cyberkinetica.com> <20050210224643.GA47912@voi.aagh.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, 2005-02-10 at 22:46 +0000, Thomas Hurst wrote: > * Antony T Curtis (antony.t.curtis@ntlworld.com) wrote: > > > If I remember correctly, MyISAM with skip-locking should rarely use > > fsync() calls... so if possible, the test could be re-run using MyISAM > > tables to see if there is any performance difference. > > Poor performance is seen on read-only tests too; no fsync() overhead > there. However, this message caught my eye: > > http://lists.freebsd.org/pipermail/freebsd-threads/2005-February/002848.html > > "Linux uses ptmalloc2 as its memory allocator, an extremely efficient > implementation whose performance under a heavily loaded multithreaded > system is impressive. FreeBSD does not." > > There are a few malloc implimentations in ports which are supposedly > very good under threaded and multi-CPU conditions, including an older > ptmalloc, but I can't seem to make MySQL work with any of them using > LD_PRELOAD (it hangs with ptmalloc and SEGV's after a few seconds of > wdrain with Hoard). This on 5-STABLE as of Jan 14, though, so don't let > that put anyone here off trying. A couple of years ago, I compiled MySQL with Hoard on AIX (8-way power3 rs6000)... and AFAIK it's still being used in a production environment. I think I'll have to play with this when if get an SMP machine... -- Antony T Curtis, BSc. UNIX, Linux, *BSD, Networking antony.t.curtis@ntlworld.com C++, J2EE, Perl, MySQL, Apache IT Consultancy.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1108105825.60161.4.camel>