…: The system was 2* Quad Core Xeon E5310, CentOS 5, Data stored on ramfs. We controlled number of cores used with /sys/devices/system… in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I also know some things about…). Starting to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server. I mean… database. The first step is to find out what MySQL instances are on the machine. It doesn’t do to just assume…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as… optimize MySQL for customer workload and Violin memory and also had a chance to do some benchmarks on my own. 2*Quad Core Xeon… percents and load was mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much IO as…
Post: A piece of Sun/MySQL Marketing
February 27, 2008 By 7 Comments
… better results on these Xeons ? or is it “Leading Virtualization Software” used with Windows is a crap ? Remembering horrible MySQL performance loss… at container configuration – setting up 6 containers on the same box to run different MySQL and Web instances looks highly dubious to… us would be using. These days you can get 2*Quad Core Xeon box w 32G RAM and 8 2.5″ hard…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… the transactions in the same order, for a recovery based on MySQL‘s binlog to work. Of course, if you remove that… typically had problems scaling on multicore boxes. The new quad core CPUs from AMD and Intel means that 8-core boxes are going to… out you can get better performance by using couple of MySQL Servers on single node. You can make them to use different…
Comment: PBXT benchmarks
November 29, 2007 By 14 Comments
…’ve encounterd completely weird results with mysql on an 8cpu server – it performed 3!! 
times slower than on the same 4cpu server: FreeBSD… @ 2.00GHz (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests done with apache benchmark on a web page… and 4 to diable extra cores): 9-11 requests/s 4 cores: 18-20 requests/s all 8 cores: 5-7 requests/s…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… Enterprise Linux AS release 4 (Nahant Update 4) 2 Ñ… Quad Core Intel XEON cpu family : 15 model : 6 model name : Intel… : Dual-Core AMD Opteron(tm) Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version…/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of data on disk…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 2, 2007 By 51 Comments
…. Multi-core scalability is a BIG problem that I’d like to see addressed with INNODB. BTW……. I think MySQL should assume machines will have 8 cores from here on out. They’re REALLY cheap. You can get quad cores from AMD + Intel now and put two chips per box. An 8 core…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… that the number varied more, depending on the availability of RAM? On a dedicated server for Mysql you will still need some memory… two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the moment the server… on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
…. 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…, and mysql processes showed in issue periods multiple copies of the same query, sometimes with also same parameters, and on OS side… later and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your…
