Use slow logs to collect unique queries and their performance continuously
When you upgrade to a new environment, you may wish to test each of the unique queries that enter the database for a safe upgrade, but how can you collect a complete set of unique queries on a heavily loaded database? When you stay on the same environment, you may want to know the performance of each of the unique queries for tuning purpose, how do you collect the data. In this lightning talk, I would like to introduce the concept and a tool based on the concept to achieve the two aforementioned purposes. They key concept is to collect new data and merge which the data already collected. While the Percona tool pt-query-digest which provides a snapshot view of what happened, my tool pv-mysql-slow-log-analyzer extends the capability by giving you a complete and evolving view of what has happened and what is happening.
MySQL DBA, Salesforce
Michael Wang is a MySQL DBA at Salesforce, he is fluent in Objected Oriented Programming in Perl.