… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… 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: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often… with MySQL 4 also because 100% durable transactions are not required anyway and it would allow to get some extra speed. It… you should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer substantial…
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… we can compare apples to apples. It performs same as MySQL 5.0 and MySQL 5.1 with small table cache. With table_open_cache increased…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… Processors | physical = 2, cores = 12, virtual = 24, hyperthreading = yes Speeds | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU… Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket…} dm-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 While…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
… table completes in 0.22 seconds giving us about 4.5 Million of rows/sec…is 32K which gives us the following speed: mysql> select * from gt order by i desc limit 10… | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 10 | | Sort_scan | 1 | +——————-+——-+ 4 rows in set (0.00 sec)…
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 6.0… hour in 5.1 and MySQL 6.0 can complete all queries within an hour. We can also see MySQL 6.0 improving query 20 speed dramatically…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so much more… one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with… of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL does not crash…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…processing and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported …, thread declared inside InnoDB 114 mysql tables in use 1, locked 0 MySQL thread id 8077, query id …hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and bunch of other benchmarks which show 5.0… development there is no free lunch and your decisions to speed something up often will mean something else becomes slower. There…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… Server 5.1.59-13.0 on October 15, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1.59-13.0 is now the current stable release in the 5.1… slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay…
