MySQL Performance 6.0rc1

[Xander Damen]

There was a similar discussion on stable a while back:

http://lists.freebsd.org/pipermail/freebsd-stable/2005-June/015874.html

which continued on performance:

http://lists.freebsd.org/pipermail/freebsd-performance/2005-June/001403.html

-- Xander

Xin LI wrote:
> 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,
>