…. 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… that improving performance probably increased the concurrency!) I put under monitoring all the parameters I could think of, and mysql processes showed… and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your post…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…m in — obviously a FreeBSD box is different). For example, [… 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family :… in our book, High Performance MySQL 2nd Edition (it’s …Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This output is…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
… on joined columns can have a significant impact on the performance of your queries. Take the following example, using the InnoDB… where; Using index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message…, from 4.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…
