MySQL benchmarks
Scott Long
scottl at freebsd.org
Wed Feb 9 23:46:46 GMT 2005
Jon Noack wrote:
> On 02/09/05 13:59, Miguel Mendez wrote:
>
>> Someone has posted a link to a newsforge article on the NetBSD lists
>> that benchmarks MySQL performance on several systems, you can see it at:
>>
>> http://software.newsforge.com/article.pl?sid=04/12/27/1243207&from=rss
>>
>> I don't know how much Linux-specific code there is in MySQL because,
>> honestly, I always try to avoid it and go with PostgreSQL, but perhaps
>> somebody with more MySQL-fu can fill in the blanks and confirm that the
>> better performance seen on Linux systems is due to how the software is
>> designed and not so much related to FreeBSD per se.
>
>
> The scalability results look promising. Also, has anyone seen what
> effect WITH_PROC_SCOPE_PTH has on performance?
>
> Jon
It's a mixed bag that has been in significant flux over the past 8
months due to threading and scheduling infrastructure sometimes fixing
bugs and sometimes introducing new bugs. On the mysql SuperSmack test,
the best results I found on a dual 3GHz Xeon were with system scope
threads under libpthread. libthr was a close second (though all threads
there are process scope by definition) and process scope libpthread was
almost as bad as libc_r. However, that was back in August, and I think
that much has changed since then. Other, non-mysql tests that I've run
recently have shown that process scope libpthread is now the overall
winner. It would be nice to come up with a new matrix of results based
on scheduler, preemption, thread library, and thread attributes. Now if
only I had the 2 days free to do that...
Scott
More information about the freebsd-current
mailing list