May 26, 2012

Post: How Percona does a MySQL Performance Audit

… to whatever environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ uname …there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first … the difference afterwards. Or we might have a test server to run on. It varies widely; some…

Post: JOIN Performance & Charsets

… (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message: select sql_no_cache count(`test`.`t1`.`char_id…, 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

… weird 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…