… statements are allocated on server and Com_stmt_send_long_data to see … tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1… hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… read more about the MRR optimization available in MySQL 5.6 here: http://dev.mysql.com/doc/refman/5.6/en/mrr-optimization… in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in the optimizer, as it is clearly a part of the optimizer’s job to select the best…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… 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: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…com/y-trudeau/resource-agents/raw/master/heartbeat/mysql You can also the whole branch from here: https://github.com…MySQL. Default is to run select count(*) on mysql.user table, so the user given should at least have select…security around the solution should be improved, a fairly easy task I believe…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…select rather traditional/prudent approach these days and will only start considering upgrade to next major MySQL version 6+ months after release. MySQL…Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL 5.0 which… direct email to my initials @percona.com…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… much greater improvements, for example…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db |… (rewriting non-SELECT queries if…
Comment: About This Blog
October 7, 2008 By 48 Comments
…Com_select, Questions, Com_update FROM conuser WHERE Questions > 10000; +—————————-+————-+———–+————+ | conuser (user@host) | Com_select | Questions | Com_update | +——— ——————+————-+———–+————+ | bandala@db2.adomain.com…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…Using the aggregated data can significantly improve query response times compared to…: $ svn checkout http://flexviews.googlecode.com/svn/trunk/ flexviews Next you…the source table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. row …
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… contained placeholders for parameters, for example “select name from user where id=?” and… cases I’ve seen 5x+ performance improvements when really large amounts of data…MySQL Server turned out to be prepare statements or cursors which were forgotten to be closed. Watch Com_stmt_prepare and Com…
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 …
