Would definitely be interesting to see the performance on a proper ZFS implementation, e.g. OpenIndiana or even FreeBSD
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
We’ve been using ZFS on FreeBSD for backup and production for a few years now. Performance …
Post: FreeBSD tests
June 15, 2006 By 15 Comments
… is available in FreeBSD bug report I’m not big expert in FreeBSD and did not saw http://wikitest.freebsd.org/MySQL before… request I made tests with 4BSD scheduler: InnoDB threads FreeBSD 6 ULE FreeBSD 6 4BSD 4BSD / ULE 1 483.22 438.1… 256 273.99 330.11 1.20 MyISAM threads FreeBSD 6 ULE FreeBSD 6 4BSD 4BSD / ULE 1 344.72 324.9…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… went to the FreeBSD scheduler, since it really looked a classic old style deadlock. Actually reserches revealed that FreeBSD is historically weak… and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your… more efficient way? I am still of the idea that FreeBSD has its responsibilities and not allow a software to put…
Comment: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
… combinations of cores in the kernel, rebooting the server. With FreeBSD 7.0 the only way to avoid the deadlock that… use all the 16 cores. I also asked for a FreeBSD 8 machine to test its new scheduler, but actually did not help (minimal). I really believe the combination FreeBSD scheduler + MySQL mutexes + Multicores (+ crappy php code := loop&query instead…
Comment: MySQL 5.1 Stability
June 30, 2008 By 12 Comments
Depends upon which version of FreeBSD… FreeBSD < 7 has problems handling mutex contentions. MySQL 5.1 does hit mutexes harder than 5.0. AFAIK, these issues has been addressed on FreeBSD 7 but I haven’t examined or tried it yet.
Comment: Connecting orphaned .ibd files
June 12, 2012 By 19 Comments
… several times steps – all right. Versions: FreeBSD 9, MySQL: Server version: 5.1.60-log FreeBSD port: mysql-server-5.1.60…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 11, 2011 By 38 Comments
@BSD: The MySQL version from the ports tree is very recent and of good quality. I don’t know if FreeBSD is able to give the same performance as Linux. A few years ago the threading support in FreeBSD was much slower that the threading support in Linux.
Comment: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
Definitely sounds like a FreeBSD bug. I’ll remember this for the future, but I haven’t seen it yet. The “umtxn” state seems like a frequent problem; seems that FreeBSD SMP support still isn’t quite mature yet.
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
… contributed by Kristian Nielsen) (Alexey Kopytov) Bug #663757 – On the FreeBSD platform, the “gcc atomic built-in†function isn’t… response_time_distribution now uses the native atomic API on FreeBSD. (Oleg Tsarev) Bug #673426 – Use of some system variables as…
