Learn about mk-query-digest at PgEast 2010
I’ll be attending PgEast this year, as I’ve done for the last couple of years, and this year I’ll also be speaking. The topic is query analysis with mk-query-digest. The official description of my talk is as follows:
mk-query-digest is a powerful open-source tool for capturing, filtering, transforming, and aggregating queries, with the ability to do all sorts of other advanced tasks too. By default, it aggregates similar queries together and presents a designed-for-DBAs report with statistics about the most important queries, so you can see where to focus your optimization efforts. This talk shows you how to use mk-query-digest to analyze your Postgres server’s workload.
PgEast 2010 has an impressive lineup of talks, which isn’t even complete yet. I’ve thoroughly enjoyed this conference in the past, and it looks like this year will be better than ever.
I wish this talk from PgEast could be repeated at the MySQL User Conference — http://postgresqlconference.org/2010/east/talks/database_hardware_benchmarking
Mark Callaghan
20 Feb 10 at 12:54 pm
I would consider doing that talk in a slightly more generic way for a MySQL Conference, but it looks a bit too late for this year’s. The great thing about that talk is that the content changes a little every year anyway. I can repeat it but cover just enough of the latest good and bad new things to make it even worth re-attending to those who have seen earlier ones.
Greg Smith
22 Feb 10 at 7:02 pm