… 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 :…s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the …
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… index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message: select…, 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: 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… that improving performance probably increased the concurrency!) I put under monitoring all the parameters I could think of, and mysql processes showed…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 38 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… just 386MB). my question is: would i get an additional performance-benefit if i ‘refragment’ the ibdata-file by dropping / importing…
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…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… comparing PostgreSQL and MySQL performance, which show how bad MySQL scales on multicore + multithread environments: http://tweakers.net/reviews/649/7 The problem with… less clear if the problem is in MySQL or in Linux, since MySQL scales fine in FreeBSD. Well, it seems that finally the…
