…the product. The more we know, the more valuable we can be to you and to our clients who might purchase the solution. Being a…a vendor wants us to evaluate their solution for a prospective client, we generally bill them for all of the time…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…time from the “base tables” (those tables on which the view was built) there must be a process to bring them up-to…the view to use it The SQL_API call flexviews.enable() is used to actually build the contents of the view, making it available for querying: mysql…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…queries which cause the large portion of the load on the system but how do we know whenever there is any possibility to make this query run better ? The…to the top level MySQL part for processing are counted the Rows_examined remains zero. It looks simple so far but it also a…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…the EXPLAIN plan for a given SELECT would show N possible index choices but only one index actually used. To some extent, MySQL…query, and it was ultimately the approach I suggested as a short/medium-term solution while they did some re-work on the process as a…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…to know the difference between just transient errors or performance problem and real problem. To be truly prudent it is better not to…to invest as much time into it. You do not only need time for testing, you need to…the failover process to be automated but a person to take a decision to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first… time we’re spending, and shortcut effort if it’s not useful, e.g. skipping analysis for a query the client’s developers are in the process…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to know how many times the ad was clicked each day? If so, you can roll all those events up into a…query parallelization, so ETL jobs written to rely on SQL tend to get really bogged down. In contrast, moving the processing outside the…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…a ratio of counters, because the process of dividing one counter by the other to get the ratio has discarded vital information. You don’t know how…time measurements, which you should, you will eventually arrive at this question. “I have a query I know is slow and is a problem for…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
MySQL has a great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you need to know…for them to be cached. Query must be deterministic – Query might provide same result no matter how many times it is run, if data remains the…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…the talk: Q: How do you install the tools? The manual has full details, but it’s important to know that the latest release for…
