EmergencyEMERGENCY? Get 24/7 Help Now!

Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27

 | February 18, 2013 |  Posted In: MySQL

PREVIOUS POST
NEXT POST
Percona MySQL Webinars
Really Large Queries: Advanced Optimization Techniques: Wednesday, February 27, 2013 10 a.m. PST

Do you have a query you never dared to touch?
Do you know it’s bad, but it’s needed?
Does it fit your screen?
Does it really have to be that expensive?
Do you want to do something about it?

During the next Percona webinar on February 27, I will present some techniques that can be useful when troubleshooting such queries. We will go through case studies (each case study is made from multiple real-world cases). In these cases we were often able to reduce query execution time from 10s of seconds to a fraction of a second.

More info:
Imagine a query that barely fits your monitor screen such as a 7 table join. In this webinar, we will discuss filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations will be shared, while pointing out common mistakes organizations often make. The talk will cover topics including:

• How to start optimizing large queries
• The use of denormalization
• The effect of join order

Interested? Register here.

PREVIOUS POST
NEXT POST
Peter Boros

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.

2 Comments

  • Peter,
    Can you have a look at this: http://stackoverflow.com/questions/15619755/why-would-adding-a-duplicate-index-make-mysql-use-the-correct-index-not-the-dup

  • Hi Tony,

    You can also post this to our MySQL discussion forums http://www.perconaforum.com/index.php?t=thread&frm_id=10&
    I’ll be adding a general MySQL category in a few weeks but in the meantime this would be the best place to post it.

Leave a Reply

 
 

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.