… GB on server), and compared 1 and 16 users in MySQL-5.1.46/PBXT and Percona Server / XtraDB – 5.1.45-rel10.2. As workload is totally memory based it will show how PBXT scales… with checkpoint activity and I am looking PBXT addresses this problem also. Beside this issue PBXT looks pretty good and in…
Comment: New MySQL Community Release Policies published
November 9, 2007 By 9 Comments
… results for common queries. The bug you mentioned had Severity 5 so it of course should not go in stable release… who downloaded it notified not to use this version. The problem with very conservative approach is – way too long delays between… not wait for 5.1 to get scaling fixes so MySQL had to go ahead. If MySQL 5.1 would be released 6 months after 5.0 (containing…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… ? Or does it mean MySQL did not scale well to 8 cores on…. The MySQL Settings are probably what is the most interesting: MySQL 5.0 … innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb…problem for benchmark specs. But what really surises me here is why not ZFS ? The ZFS MySQL…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads queries/sec 1 161 2 107 …problem in this case is key buffer contention which unlike popular belief not fully fixed by changes done in MySQL 4.1… query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other hand it scales quite nicely …
Page: Presentations
May 3, 2006 By
…MySQL as well as solve other performance related problems. Download Innodb Performance Optimization MySQL…MySQL Performance Optimization data as well as for general MySQL application design practices. Download MySQL: New Features in versions 4.1, 5.0, 5.1…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…MySQL 5…problem…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…-one commands. For example, ‘top -n 1‘ and ‘uptime’. That shows me what … use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know…The stock MySQL server’s limitation of one-second granularity makes it hide problem queries …a question of where they fall on the scale. Now I analyze these one at a…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…5.0.30 and 5.1.14. So I took for tests: 5.0.27, the release with both problems 5… with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were … http://www.mysqlperformanceblog.com/files/benchmarks/innodb_scale.html (Note: This benchmark is synthetic micro…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… main factor because sphinx and MySQL respond from cache. We however see for pages which have the problem it is Sphinx which… be enough but for large scale application I’d recommend to looking down to 5 minutes or even 1 minute intervals and making… for less complicated single MySQL server application there is often the question if it is MySQL server causing the problem or if application…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…today. However, the scaling features of Shard… all the complex problems in the world …MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2 group by 1,2,3 order by 3,1… ffc86c559e06009a743d891ce1e4fc4f [count(*)] => 512 ) 1427 rows returned (5.0057470798492s, 4.9994130134583s,…
