…’m continuing my experiments with different OS and today I tested FreeBSD 6.0 on my box. (more details about box and… is available in FreeBSD bug report I’m not big expert in FreeBSD and did not saw http://wikitest.freebsd.org/MySQL before… NTPL Schedulers comparsion. By request I made tests with 4BSD scheduler: InnoDB threads FreeBSD 6 ULE FreeBSD 6 4BSD 4BSD / ULE 1 483…
Comment: How Percona diagnoses MySQL server stalls
…, then it is a FreeBSD bug! All mysql processes stuck in ‘umtxn’ status. I did many tests enabling all different combinations of cores in the kernel, rebooting the server. With FreeBSD 7.0 the only… for a FreeBSD 8 machine to test its new scheduler, but actually did not help (minimal). I really believe the combination FreeBSD scheduler…
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… not working correctly. (Oleg Tsarev) Bug #676147 – The development environment test of option log_slow_slave_statements for row-based replication…
Comment: PBXT benchmarks
… on the same 4cpu server: FreeBSD-6.2/7.0, amd64 both sched_4bsd an sched_ule tested 2xIntel Xeon(R) CPU E5335 @ 2.00GHz (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests…
Post: JOIN Performance & Charsets
…`) AS `COUNT(t1.char_id)` from `test`.`t1` join `test`.`t2` where (`test`.`t1`.`char_id` = convert(`test`.`t2`.`char_id` using utf8)) 1…_cache count(`test`.`t1`.`char_id`) AS `COUNT(t1.char_id)` from `test`.`t1` join `test`.`t2` where (`test`.`t2`.`char_id` = `test`.`t1`.`char… 4.33 to 3.12 seconds. This test was performed with MySQL 5.0.67, FreeBSD 7, on a box with 2GB…
Comment: Quick look at Ubuntu 6.06
…’m continuing my experiments with different OS and today I tested FreeBSD 6.0 on my box. (more details about box and…-look-at-ubuntu-606/). Initially I was very pessimistic about FreeBSD, as results were (in transactions/sec, more is better. for…
Post: Percona-XtraDB version 9.1
… (x86_64 and i386) Ubuntu Hardy (x86_64 and i386) FreeBSD 8 (x86_64 and i386) OpenSolaris (x86_64) Fixed bugs… too optimistic Fixed mysql-tests: mysql mysql_upgrade ssl tests enabled rpl_killed_ddl and innodb-autoinc tests Percona-XtraDB obsoletes mysql-server…
Post: How Percona does a MySQL Performance Audit
… to adapt to whatever environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ uname -a Linux…, and show the difference afterwards. Or we might have a test server to run on. It varies widely; some clients have a test server, some don’t; some have a formal QA process…
Comment: How Percona diagnoses MySQL server stalls
… investigation. The ‘deadly’ combination: MyISAM mutex on the key cache, FreeBSD scheduler, and multiple cores (on different CPUs!) (AMD) MySQL would… processes in the queue waiting (load reported hundreds) Doing many tests at the end the temporary solution was to shut down…
Post: Percona Server 5.1.50-rel12.1
… Server 5.1.50-rel12.1 on FreeBSD (Oleg Tsarev) Bug #650977 – Fixed failed tests. (Oleg Tsarev) The binary packages are available…

