…ve heard that talk from Seppo (Codership) before. MySQL Query Anti-Patterns that can be moved to Sphinx… problem to solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert … conference and why? Best answer in the comments below wins the pass. Include a link…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
…mysql> /* comment*/ select count(*) from fact where val like “%c%”; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> /* another comment…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…(25) DEFAULT NULL, `l_shipmode` char(10) DEFAULT NULL, `l_comment` varchar(44) DEFAULT NULL, PRIMARY KEY (`l_orderkey`,`l_linenumber… time to complete the query for in-memory workload and 6.6x less times as compared to BKA MySQL 5.6, and 965x… MySQL 5.6. While for in-memory workload the reduction is query time is 3.5x when compared to both MySQL 5.5 and MySQL…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… revenue, c_acctbal, n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_custkey = o_custkey… query time for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL… MRR, and the query time for MySQL 5.6 and MariaDB 5.5 jumps to ~11min (this is the query time for MySQL 5.5) While…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query Cache… place dynamic comments in the query, have extra space or use different case – these would be different queries for query cache. Only SELECT queries are cached…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical values for review… statements; * reviewing and commenting on queries. Despite its lack of ability to save predefined reports in the web interface for easy access, it…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…_swedish_ci Checksum: NULL Create_options: Comment: with totally misleading information. So …queries: (again look on comparison with other engines in Google Spreadsheet or in summary table at the bottom) Query Q1: mysql…. InfiniDB shows really good time for queries it can handle, quite often better…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… I want to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l…` date NOT NULL, `l_shipinstruct` char(25) NOT NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT NULL… execution of query, as MySQL used index to scan rows and then did access to data to read other columns. But for 6…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… implementation in MySQL is well though of in regards to avoiding trouble. For example you can’t ALTER log table while query is… rather handy is UDF or stored procedure to “normalize” query by removing comments and replacing constants with some placeholders as this would allow to aggregate log entirely in SQL finding most frequent slow query…
Post: mk-query-digest, query comments and the query cache
… in query comments. The support for embedded attributes makes some cool tricks possible. Peter and I co-presented a talk at this past MySQL… in the query comments. Also notice the query with static comments. There are 1000 hits and 1000 misses because MySQL treats identical queries with identical comments as…