… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice * l_discount…KEY `li_shp_dt_idx` (`l_shipdate`), KEY `li_com_dt_idx` (`l_commitdate`), KEY `li_rcpt_dt_idx… not so big we could speak about big improvements with using MRR here. What is interesting is …
Post: Tools and Techniques for Index Design Webinar Questions Followup
October 4, 2012 By 5 Comments
… – November 2, 2012. See http://store.percona.com/catalog.php?category=17 for details on…exciting new ways that MySQL can use indexes, such as: Index merge improvements. But I expect…select-list. The difference is that QUBE helps you to predict quantitatively how much a new index is likely to improve…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… `t1` WHERE `id` < 1000 compare this to: SELECT AVG(LENGTH(COMPRESS(`colTextField`))) FROM `t1` WHERE `id… pages. COMPACT became the default after MySQL 5.0.3 and has a … We were able to show a 70% improvement in queries against this table when … Thanks for reading my first mysqlperformanceblog.com…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…default, adding relevance sorting to the MySQL queries would make them even slower, …, and if you can form a SELECT query that returns the “new” data (…you can get a lot of speed improvement because you’re searching data without … 24-27. See http://www.percona.com/training/ for details on our training…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… check out the improvements in mysql 5.6 http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html These improvements sound interesting to page flush and i/o problems? Explicit Partition Selection, Split Kernel…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…com/2009/03/pbxt-is-fast-no-kidding.html) by Mark Callaghan shows that PBXT can actually out perform InnoDB with SELECTs…an excellent addition to XtraDB). Both methods improve the management of the asynchronous writes….) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…com/files/benchpbxt/phptest.lua The mysql.start script with startup parameters for InnoDB and PBXT http://www.mysqlperformanceblog.com/files/benchpbxt/mysql…: SELECT name FROM $tableName WHERE id = %d READ_KEY_POINT Query: SELECT …but I hope PBXT team will improve performance to make the difference …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-…(the query Q0 is: select avg(c1) from (select year,month,count(*) as …After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA… history), the documentation also needs improvements. The fact it does not …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…comming from “traditional” databases you’re likely to be shocked by MyISAM behavior (and default MySQL…. By default MySQL treats updates as higher priority operations. You can use SELECT HIGH_PRIORITY or…UNLOCK TABLES) be careful. This option may improve performance dramatically in certain cases by …
