…Quad Core Xeon E5310, CentOS 5, Data stored on ramfs. We controlled number of cores…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…concurrency issues it does not mean CPU increase does not mean concurrency… threads…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the… scaling on multicore boxes. The new quad core CPUs from AMD and Intel means that 8-core boxes are going to be common…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… completed? HT: A query thread normally posts about 64 …5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5… to 32 GB, 4x quad-core AMD Opterons. Yes it helped…been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…Linux AS release 4 (Nahant Update 4) 2 Ñ… Quad Core Intel XEON cpu family : 15 model : 6 model name … size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB …, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec…
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… the concurrency!) I put under monitoring all the parameters I could think of, and mysql processes … 200k/300k so I observed the single mysql threads and I saw that many where stuck in …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…*Dual Core CPUs seems to do very well, while with even just two Quad Core CPUs scalability … write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The …, especially in locking in 5.0 and even more to come with MySQL 5.1 and row …
