MySQL Performance 6.0rc1
Xin LI
delphij at frontfree.net
Wed Oct 26 02:58:11 PDT 2005
Hi, Marian,
在 2005-10-26三的 11:14 +0200,Marian Hettwer写道:
> Hi Folks,
>
> I'm using RC1 on some of my test servers and workstations. So far, it
> runs very good (as in stable and fast) :)
> However, I thought of doing a small benchmark of MySQL in comparison to
> Linux 2.6.8 (Debian Sarge) and the results are kinda... shocking.
[...]
> Any Ideas where this huge difference comes from? Did I oversee some
> debugging features still active in RC1 ?
There are many factors that can affect the performance of MySQL. Would
you please post the output of "dumpfs /var | head -n 21" on your server?
(Replace /var with whatever mountpoint that your database is stored in).
Some observations that I think can affect MySQL performance:
- Our malloc(3) implementation might be sub-optimal for the workload.
- Lack of some POSIX system call which was implemented in other ways
(e.g. we do not have fsyncdata yet)
- Some detailed implementation difference between our and Linux's
threading library, or MySQL itself.
I think David (davidxu@) had worked on performance of MySQL and he may
have some suggestions.
BTW. What file system are you using on your Debian test? What's the
mount options?
Cheers,
--
Xin LI <delphij delphij net> http://www.delphij.net/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: This is a digitally signed message part
Url : http://lists.freebsd.org/pipermail/freebsd-current/attachments/20051026/194ab929/attachment.bin
More information about the freebsd-current
mailing list