Peter Boros

Consultant, Percona

Peter joined the European consulting team in May 2012. Before joining Percona, among many other things, he worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. Peter's first and foremost professional interest is performance tuning. He currently lives in Budapest, Hungary with his wife and son.

Sessions

Advanced query optimization techniques on large queries.

This talk is looking to fill some of the gap between the ability of reading explain output and the ability to optimize really large queries (imagine a 7 table join). I would like to discuss practical techniques through real-world practical examples, displaying common flaws, encountered throughout my work as a consultant. The talk will cover, but will not be limited to:

- How do you... [read more]