Re: mysql scaling questions

Gergely CZUCZY wrote:
On Sun, Dec 30, 2007 at 02:35:56PM +0100, Kris Kennaway wrote:
Gergely CZUCZY wrote:

I appreciate that you might be constrained by local requirements, but it's really not meaningful to compare different mysql versions if your goal is to study OS performance.
It'd be a PITA to install the both versions. Maybe now, that the ports freeze is over, i can
do something. But honestly, every mysql version was faster on linux, than eny on FreeBSD,
even the .22 one was faster. We start work on Jan02, I will see what can I do.
Regardless, we need a stable baseline to compare to.
Cannot do it sooner then january. Any recommended versions?

Either 5.0.45 on both, or 5.0.51 on both, please.

Still waiting for your sysbench command lines :)
There were 2 scripts and a sources file with options:

basicall that's everything. I know it's a but complex, but this was all behind it.

OK, that was very important since you're changing defaults.

It looks like myisam is doing huge numbers of concurrent reads of the same file which is running into exclusive locking in the kernel (vnode interlock and lockbuilder mtxpool). Does it not do any caching of the data in userspace but relies on querying into the kernel every time? innodb doesn't have this behaviour.

Kris

_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: mysql scaling questions
    ... It'd be a PITA to install the both versions. ... Maybe now, that the ports freeze is over, i can ... It looks like myisam is doing huge numbers of concurrent reads of the same file which is running into exclusive locking in the kernel ... Weenies test. ...
    (freebsd-performance)
  • input method on fc3?
    ... FC3 and soundcard ... >> without problems and sound works fine. ... What modules were loaded with kernel ... I can install and configure samba on Linux as easily as I can install ...
    (Fedora)
  • Fedora Core 2, Averatec 3220 notebook
    ... I recently bought an Averatec 3220 notebook computer and have spent some ... Following is a detailed "howto" guide for installing Linux (Fedora Core ... Linux distro, which is easy to install and use, and for lots of answers ... We need one because the default Fedora Core kernel doesn't grok NTFS ...
    (Fedora)
  • Yum upgrade from F8 to F9 with KDE desktop - installation notes
    ... nVidia drivers from Freshrpms, and I had to install the latest nVidia driver ... kernel in step 5; once I did that, the dkms package (which gets installed from ... Use your preferred method to install the above file: ...
    (Fedora)
  • Yum upgrade from F8 to F8 with KDE desktop - installation notes
    ... nVidia drivers from Freshrpms, and I had to install the latest nVidia driver ... kernel in step 5; once I did that, the dkms package (which gets installed from ... relevant info to do a yum upgrade a bit daunting. ... Use your preferred method to install the above file: ...
    (Fedora)