… Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6…Yonkovit, our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, …, “Conquering BigData with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved…to test all different solutions, and measure the resulting performance! Q: Bill, back to the query where you were trying to…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
…how to perform typical but challenging MySQL database administration tasks. My focus will be on the following tools: pt-query-digest, to select the queries you should try to improve to get optimal response times pt-archiver, to efficiently purge …
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… can measure how a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your… it’s unable to connect to the MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query parsing has been improved. Bug fixed #1080648 (Vlad Lesin). Missing build dependences have been added to the README file…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… the original query execution time. It may be possible, therefore, to refresh an MV based on a query that takes 45 minutes to execute…(), it but still provides improved performance during refresh by accessing summarized data. I hope this helps you understand how Flexviews can help you…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… be exploited by scale up. Scale up can improve query performance when there is enough resources to support the added parallelism, and when one… 1 ORDER BY c LIMIT 10; The next queries show how performance is improved when Shard-Query adds parallelism when “subqueries in the from clause…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it… glance whether a query is going to be possible to improve a lot, and a simple mental calculation can then tell me how much total gain I can get from it. Queries…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…to improve it? – if not, we’re done.” In databases, we care most about the work the database is doing. That is, queries…queries blocking others, but it’s nowhere near precise enough to find and diagnose the kinds of sub-second performance…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… the most common questions we hear is how to build high-performance systems to do this work. Let’s see…a lot about how you need to query the data. It is a hard question to answer, and … primary key(day, ad, is_blue) ); What can we improve here? Especially assuming that there are indexes other…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… have to decide on couple few questions on how to tackle application performance. These questions… fine tuning which gives little improvement or more application changes such as…to design the application more efficient way and you probably do not want to need consultants to review every simple query…
