…use new the Dell PowerEdge R420 with two Intel(R) Xeon(R) CPU E5-2450 0 @ 2.10GHz,…InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we…myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… benchmarks for this device were performed primarily on a Dell R720 with 192GB of RAM and two Xeon E5-2660 processors that… throughput with latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read… we compare the performance of the P320h on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted…
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… claim the good performance, and this is where T2000 performs subpar in …Intel Xeon vs T2000: # XEON mysql> select benchmark(100000000,1+2); +————————–+ | benchmark(100000000,1+2) | +————————–+ | 0 | +————————–+ 1 row in set (1.50 sec) # T2000 mysql…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… Intel Woodcrest preview benchmarks which have some numbers for MySQL as well. From these numbers performance looks great and it looks like finally Intel… also looks at performance of Irwindale based Xeon and Sun T2000. Results are close to the ones I had in MySQL Performance Landscape presentation…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… bound benchmark with working set fitting in memory. MySQL and PostrgreSQL Scalability on Xeon Woodcrest, Opteron and Niagra Pretty interesting to see…. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron comes second and older Intel Xeons as well as Niagra being outsiders. Niagra scalability is one more interesting story. As you can see MySQL 4…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
… some level of performance of tablet CPUs: Processor : ARMv7 Processor rev 9 (v7l) processor : 0 BogoMIPS : 1993.93 mysql> SELECT BENCHMARK(10000000… Cisco UCS server: model name : Intel(R) Xeon(R) CPU X5670 @ 2.93GHz bogomips : 5851.73 mysql> SELECT BENCHMARK(10000000,ENCODE(‘hello’,'goodbye…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… Intel SSD 910 under tpcc-mysql workload and compare with HDD RAID10 Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R… publishing) Intel SSD 910 handles MySQL workload quite well, I did not face any problem working with this card. I think Intel SSD 910 is suitable to use with MySQL / Percona Server, especially if you are looking for quick performance boost in…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version… and performance parameters may vary a lot in next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…) 2 Ñ… Quad Core Intel XEON cpu family : 15 model : 6 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping … size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM /… results, but I hope PBXT team will improve performance to make the difference a bit better. Unfortunately …
