Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: query plan (reset)

Profiling your slow queries using pt-query-digest and some love from Percona Server
+2 Vote Up -0Vote Down
posted by Ovais Tariq on Wed 28 Dec 2011 12:23 UTC
Tags:
(edit) mysql, innodb, performance, optimization, query plan, profiling, temporary tables, queries, slow query, query analysis, long_query_time, query execution, mk-query-digest, general query log, tmp_table_size, percona server, Percona Toolkit, 95th percentile, log_slow_verbosity, microslow patch, microtime, pt-query-digest, slow logging
This guide will get you up and running with how to identify the bottleneck queries using the excellent tool pt-query-digest. You will learn how to use and analyze the output returned by pt-query-digest. You will also learn some differences between slow query logging in various MySQL versions. Later on in the post I will also show you how to make use of the extra diagnostic data available with Percona Server.
How to avoid an extra index scan in MySQL
+0 Vote Up -0Vote Down
posted by Baron Schwartz (xaprb) on Fri 27 Jul 2007 12:07 UTC
Tags:
(edit) mysql, sql, null, explain, join strategy, query plan, sakila

Is your MySQL server doing an extra index scan on queries that need to check a key for matches or NULL? It's easy for this to happen accidentally, but it's also easy to fix, especially in MySQL 5.0 and up. Here's how.

Showing entries 1 to 2

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.