Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…of memory 26 EC2 Compute Units (8 virtual cores with 3.25 EC2 Compute …8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5…buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… box had 8 cores it is little use for MySQL as only one query is ran concurrently, same can be told about 8 hard… is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… 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 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6% slower with 8 cores, meaning regression…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read… 5.1 and around 6 for Percona Server 5.5 which is way too little for what you would expect from 24 core … you still can’t get use of more than 8 cores effectively (which would correspond to single CPU socket these …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does Helgrind find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a… This conflicts with a previous write of size 8 by thread #1 ==9090== at 0x6BC9FFF: mutex_spin_wait (… by 0×788560: sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) (sp_head…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…that MySQL 5.5.8 has periodic drops here, too. The margin between Percona Server and MySQL is about 2500-2800 NOTPM (~15% difference). MySQL 5.5.8 now…lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server_id=1 local_infile=1 …
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
… experiments we went through and just share final numbers. On 8 core Opteron Box we were able to achieve 275K inserts/sec…’s the deal ? First MySQL 5.5 (frankly I did not try Percona Server 5.1 in this case) With MySQL 5.1 and Innodb Plugin we could… (per oprofile), which went down to about 15% in MySQL 5.5.8 with 8 concurrent threads. This both shows there is a substantial gains…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… the core counts and effective CPU speeds can be a bottleneck. My experience and intuition are that an actual concurrency of 8… I was not able to outstrip RDS 5.1‘s performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get better performance with Percona Server 5.1, probably…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… ’0′, `zip` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default… 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1…
