Re: Benchmark MySQL Performance On FreeBSD And Linux

On Friday, 16 December 2005 at 11:20:12 +0800, huang leo wrote:
>
> We had evaluated MySQL performance on FreeBSD and Linux. The result is
> attached.

Thank you!

This is some of the most plausible information I've seen in a while.
I'm forwarding it to a MySQL internal list, and I expect we'll discuss
it in much detail.

A few comments:

- You refer to bug http://bugs.mysql.com/bug.php?12251. Did you
experience these crashes yourself? If you look through that bug
report, you'll find that we (MySQL) have had great difficulty
reproducing the problem. Many people have reported that they have
no trouble under the same conditions, and we were half thinking it
might be related to (but not the fault of) the hardware in
question. Your hardware is very different, so it would help us a
lot if you're also able to reproduce it.

- There's been a lot of discussion on the FreeBSD lists recently
suggesting that the performance problems are related to the choice
of timer. I've never been convinced, and your results suggest to me
that this isn't the real problem. Still, it would be nice to
compare the results using various timer options.

If you haven't been following the discussion, it's in the archives
for the FreeBSD-current mailing list. Let me know (in private mail)
if you'd like me to forward them to you.

- I'd be very interested in the deadlocks you've been experiencing.
If you have any additional information, please let me know.

Do you have scripts for these tests? I appreciate that the
information is mainly there, but it would be easier for us if the
scripts are available.

Thanks again for the report
Greg
--
See complete headers for address and phone numbers.

Attachment:pgpiBRupUipGJ.pgp
Description: PGP signature

Relevant Pages

  • Re: MySQL Performance 6.0rc1
    ... Nevertheless I run a production MySQL on a double-Xeon (Supermicro ... etc) which eventually kill MySQL with FreeBSD ... CPU: AMD OpteronProcessor 246 ... <ACPI PCI bus> on pcib0 ...
    (freebsd-current)
  • What am I doing wrong with MOUNT?
    ... I'm brand new to FreeBSD and Unix world in general. ... I installed MySQL version 3.23 from the ports ... of his database that I had MySQL dump on his FreeBSD server and FTP'd it to ... I mounted the new drive 1 to a temporary mount point and used the cp command ...
    (freebsd-newbies)
  • Re: FreeBSD MySQL still WAY slower than Linux
    ... I hope this can help us out to get MySQL humming on -STABLE, ... >> To make benchmarks a help provided to improve FreeBSD, ... > This box is currently setup to slave from the master. ... > System crashed while simply slaving from the master. ...
    (freebsd-stable)
  • Re: FreeBSD MySQL still WAY slower than Linux
    ... is that the Mysql folks have agreed to setup ... >tests to profile mysql on identical hardware running FreeBSD and Linux ... I was seeing the same sort of super-smack numbers that everyone's been ...
    (freebsd-stable)
  • Re: Mysql server not able to stay running on anything but Linux?
    ... >> As you know from various threads on the FreeBSD ... >> significant issue just reproducing the problem. ... > So far we have had only one crash that seemed to have ... >> MYSQL doesn't ...
    (freebsd-questions)