We are experiencing this freezing issue as well on FreeBSD 7.1 with MySQL 5.1.32. Its a pretty high traffic site, but I… make the server stop and restart. We were running FreeBSD 7.0 and MySql 5.0 and never saw this issue. Any help… skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait_timeout = 15 key_buffer = 16M…
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-sized… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far…
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.
Post: Percona XtraBackup 1.5-Beta
December 13, 2010 By 6 Comments
… can now be built from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases (fixes bug… & 5.1 with built-in InnoDB xtrabackup_55 – for use with MySQL 5.5 (this binary is not provided for the FreeBSD platform… been updated to build from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases. (Alexey Kopytov…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
… of 3.12 seconds and had the following EXPLAIN: *************************** 1. row *************************** id: 1 select_type: SIMPLE table: t1 type: index possible_keys….t1.char_id rows: 1 Extra: Using index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note….33 to 3.12 seconds. This test was performed with MySQL 5.0.67, FreeBSD 7, on a box with 2GB RAM.
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…FreeBSD box is different). For example, [percona@db1 ~]$ uname -a Linux hostname.domain 2.6.18-92.el5 #1…/proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
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…) CPU E5335 @ 2.00GHz (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests done with apache benchmark on… 4 cores: 18-20 requests/s all 8 cores: 5-7 requests/s, whatever did I try to do – nothing really…
