…query execution time. It may be possible, therefore, to refresh an MV based on a query that takes 45 minutes to execute…for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK,… Flexviews can help you ensure fast response times in your application …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should…would recommend using Percona Server with enabled expand_fast_index_creation feature, as I just wrote this…multi language data. Q: What to do if Query Execution Plan changes for the worst during Upgrade? This…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…but either it isn’t running queries anymore, or it runs such fast queries that you can’t capture them… use mk-query-digest to convert this into a query log, and examine the log. In MySQL 5.1…the offending transaction is idle, and not continuing to execute more queries, then it won’t work. In addition,…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… MySQL Replication is single threaded, which means if you have any long running write query it clogs replication stream and small and fast updates which go after it in MySQL binary log can… any other query execution. So if you have transaction containing millions of simple updates instead of one large update to help MySQL replication…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…MySQL version. Now why do not we use general log instead ? Unfortunately general logs queries before queries are executed (and even parsed) so it can’t contain query execution information such as execution…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… logs filter and write filtered logs – the queries are formally executed but it is rather fast as there is no any real data… will increase a bit (though not much because query execution on such slave is very fast) and what is more important you will…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… being confused, thinking MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache is not. It…. It is not that fast Query Cache is fast compared to running the queries but it is still not as fast as specially designed systems…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as…finding how many queries were accumulated in the logs or finding 10 last queries is not fast. The good… concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… Pool and have multiple MySQL Query Cache instances hashed by query hash. It would help to reduce complexity dramatically. Fast Invalidation Right now when… query cache and there are multiple connection requesting the same item. What MySQL will do ? It will allow all of them to execute…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… strong guarantees. It is same as with MySQL Replication – the reason it is fast and has low performance overhead on the master… include support for query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back…
