… trashing issues with count of theads 100+. In this case performance of InnoDB degraded dramatically. The problem was in the mutex… for comparison of overall performance All releases were compiled from sources with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and… release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping : 6 cpu…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
… is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with baseline Fusion-io ioDrive card Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R…. The performance of Intel SSD 910 is about ~30% worse, but it is expected for this price level. I think Intel SSD 910…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… the server), and compare performance with SAS hard drives. System specification Dell PowerEdge R610 Memory: 48GB CPU: Intel(R) Xeon(R) CPU X5650… mention that on these datasizes, sysbench workload is pretty nasty, MySQL will mostly reads and writes pages from buffer pool (replacing…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…question arises how much logging impacts on performance. When we do performance audit often we log every …release 4.7 (Final) There are four CPUs Intel(R) Xeon(R) CPU 5150 @ 2.66GHz, 32GB RAM….than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance and stability standpoints. I can’t say that my experience was totally flawless, I bumped into two bugs: MySQL 5… Benchmark goal: Test how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… environment: server Dell SC1425, with 4GB of RAM and Dual Intel(R) Xeon(TM) CPU 3.40GHz. InfoBright (ICE) version: 5.1… to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data/d1/AirData… if you want to compare or get info about air performance.
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… peak filtering speed of about 7M rows/sec on this Intel(R) Xeon(R) CPU 5130 @ 2.00GHz CPU. This number is… rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> DECLARE t… affect performance and created the following table: CREATE TABLE `m4` ( `c` char(128) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1 mysql> show…
Comment: MySQL, AIX5L and malloc()
February 18, 2009 By 11 Comments
… mysql on aix5.3(powerCPU) After a migration from SLES9 (Intel Xeon) to AIX 5.3 (Power6) we run into severe performance problems with MySQL 5.0. (64bit) MySQL and IBM Support… real cpu´s and virtual cpu´s. Mysql supplied many new compiled (Xlc + gcc) mysql 5.0.x versions. Even though all…
Post: How number of columns affects performance ?
September 28, 2009 By 12 Comments
…. I added one to t99v1 table and repeated the query: mysql [localhost] {msandbox} (test) > select max(t1+0) from t99v1; +———–+ | max(t1+0) | +———–+ | 0 | +———–+ 1 row in set (3.26 sec) mysql [localhost] {msandbox} (test) > explain select max(t1+0) from t99v1… full table scan. P.S Tests were done on MySQL 5.4.2 on Intel(R) Xeon(R) CPU E5405 @ 2.00GHz CPU.
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…GenuineIntel cpu family : 6 model : 29 model name : Intel(R) Xeon(R) CPU E7450 @ 2.40GHz stepping : 1 cpu …bits physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-… read detailed investigation what is the reason of performance drop in next post. And last one …
