May 23, 2012

Post: FreeBSD tests

… 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

… 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

… 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

Depends upon which version of FreeBSDFreeBSD < 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: Which Linux distribution for a MySQL database server? A specific point of view.

@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

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

… 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…

Comment: Performance improvements in Percona 5.0.83 and XtraDB

fred, We will do FreeBSD when there is interest from customers for FreeBSD binaries, or when we have enough spare time (not going to be soon :) ) to do them.

Post: xtrabackup-0.7 (RC)

… recovery of double buffer Also we added binary builds for FreeBSD 7 64bit platform You can download current binaries (64bit) RPM…, tar.gz for Mac OS / Intel and .tar.gz for FreeBSD 7: http://www.percona.com/mysql/xtrabackup/0.7/. By…

Comment: MySQL random freezes could be the query cache

We are experiencing this freezing issue as well on FreeBSD 7.1 with MySQL 5.1.32. Its a pretty … to make the server stop and restart. We were running FreeBSD 7.0 and MySql 5.0 and never saw this…