…, 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 way… for a FreeBSD 8 machine to test its new scheduler, but actually did not help (minimal). I really believe the combination FreeBSD scheduler…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
…`) 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 RAM.
Comment: 5.0.83-build17 Percona binaries
August 3, 2009 By 19 Comments
I have problems with -highperf under freebsd 7.2 (mysqld process locked in ucond state). So test it before using in production.
Comment: PBXT benchmarks
November 29, 2007 By 14 Comments
… 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… 4 cores: 18-20 requests/s all 8 cores: 5-7 requests/s, whatever did I try to do – nothing really…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… whatever environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ … ~]$ tail -n 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model :…the difference afterwards. Or we might have a test server to run on. It varies widely;…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 25 Comments
… 4.4.7 does the same as your x64 box but 5.2.4 works as your FreeBSD box. Your windows test could…
