… recovery of double buffer Also we added binary builds for FreeBSD 7 64bit platform You can download current binaries (64bit) RPM for… Mac OS / Intel and .tar.gz for FreeBSD 7: http://www.percona.com/mysql/xtrabackup/0.7/. By the same link you can find…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… end to a 3 weeks long 24×7 research. MySQL 5.0.81 on FreeBSD 7.0 4 quad core Xeon 16gb I was just hired by a web company and they experienced mysql crazy… and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your post…
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: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
Baron, then it is a FreeBSD bug! All mysql processes stuck in ‘umtxn’ status. I did many tests enabling … combinations of cores in the kernel, rebooting the server. With FreeBSD 7.0 the only way to avoid the deadlock that was… a FreeBSD 8 machine to test its new scheduler, but actually did not help (minimal). I really believe the combination FreeBSD scheduler + MySQL…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
We are experiencing this freezing issue as well on FreeBSD 7.1 with MySQL 5.1.32. Its a pretty high traffic site… make the server stop and restart. We were running FreeBSD 7.0 and MySql 5.0 and never saw this issue. Any help…-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait…
Comment: Improved InnoDB rw_lock patch
November 19, 2008 By 3 Comments
… my trust in FreeBSD before applying the patch. Running our 7G InnoDB database on MySql 5.0.67 on FreeBSD 7.0 on a…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1… -n 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
… recently upgrade to mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables(small… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
… index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message: select… index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message: select….33 to 3.12 seconds. This test was performed with MySQL 5.0.67, FreeBSD 7, on a box with 2GB RAM.
Comment: PBXT benchmarks
November 29, 2007 By 14 Comments
… results with mysql on an 8cpu server – it performed 3!! 
times slower than 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 done with apache benchmark…
