…. I was expecting an influence, because those idle threads are presents in internal MySQL list objects that need to be scanned and… 8GB of RAM and a Core i5 CPU (dual core with HT enabled). Since my goal is to test concurrency, I decided to use…%. I also hacked a bit the “run_mysql.sh” script to allow more processing threads (100) instead of the max of 20…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
…V40z, Solaris 10, 4 x Dual Core Opteron @ 2.2GHz …threads Quadxeon with enabled concurrent-insert Quadxeon –skip-concurrent-insert Sun V40z with enabled concurrent-insert Sun V40z –skip-concurrent…MySQL developers are working on CPU-depended rw-locks implementstation, this will be available in MySQL…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… of RAM Fedora Core release 5 (Bordeaux) 2 Ñ… Dual Core AMD Opteron cpu family : 15 model : 65 model name : Dual-Core AMD Opteron(tm) Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version… for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) …MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512 …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… 2*Dual Core CPUs seems to do very well, while with even just two Quad Core CPUs…so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important … write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…(about 100% of 400% available, MPM and dual core reports 4 processors). We have 6Gb …mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql… # Approx 20% of buffer pool innodb_thread_concurrency=64 # Default is 8 wich is …
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were …=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512…: CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) …
