… with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…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…5.1 and MySQL 6.0 can complete all queries within an hour. We can also see MySQL 6.0 improving query 20 speed…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… which is almost 8500 tables/sec which is a great speed. We can note significant writes to the disk during this… bit worse than MySQL 5.0.85. So the problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5.4.2… down to 64 so we can compare apples to apples. It performs same as MySQL 5.0 and MySQL 5.1 with small table cache. With table…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…virtual = 24, hyperthreading = yes Speeds | …compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql…0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… look at MySQL 5.0 Benchmarks Whitepaper and guess which type is this ? You can also compare it to my MySQL Performance 5.0 vs 4.1 presentation… development there is no free lunch and your decisions to speed something up often will mean something else becomes slower. There… MySQL 5.0 was stable but were not fixed, others, such as broken group commit could have been handled better. Same applies to comparing MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…all kinds of other things. In MySQL 5 number of Innodb performance counters …rounds”. Spin locks are low cost wait, compared to OS wait, it is … declared inside InnoDB 114 mysql tables in use 1, locked 0 MySQL thread id 8077, …Innodb builds for some pages to speed up row lookup replacing btree search…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… instead of MySQL or having Sun box replaced with comparable Dell or HP…. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in …_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_… I’m curious how much speed benefit did it really provide in…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
… 5% of…speed.) Three: measure it more scientifically. Use our patched server, which gives you a USER_STATISTICS table. mysql…0 ROWS_UPDATED: 1882292 SELECT_COMMANDS: 0 UPDATE_COMMANDS: 580431 OTHER_COMMANDS: 338857 COMMIT_TRANSACTIONS: 1016571 ROLLBACK_TRANSACTIONS: 0 You can compare…instead. [1] There…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
….0 within next 3 to 6 months. In fact Sphinx 2.0.3-rc is promised within 1 month. What MySQL…in MySQL 5.6 and Claimed to be faster than MyISAM’s I really would like to see some benchmarks comparing…cases people use Sphinx not because it is faster – speed might not be the main thing on smaller …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… in terms of size and spindle speed. I need to know how …5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL…db1 ~]$ ps -eaf | grep mysqld root 3137 1 0 Nov19 ? 00:00:00 /bin/sh…wrong. When I find something, I compare it against the server’s variables…
