MySQL: log slow queries and queries which don't use indexes

Bug #1404171 reported by Roman Podoliaka
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Fix Committed
Wishlist
Bartłomiej Piotrowski

Bug Description

OpenStack services often use very inefficient queries to MySQL. It would be nice to spot this early in the release cycle.

We could ask MySQL to log slow queries and/or queries not using indexes (and thus leading to full scans).

Stanislav Makar (smakar)
Changed in fuel:
importance: Undecided → High
status: New → Triaged
Changed in fuel:
importance: High → Wishlist
Changed in fuel:
assignee: Sergii Golovatiuk (sgolovatiuk) → Bartlomiej Piotrowski (bpiotrowski)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-library (master)

Fix proposed to branch: master
Review: https://review.openstack.org/156534

Changed in fuel:
status: Triaged → In Progress
Changed in fuel:
milestone: none → 6.1
Changed in fuel:
assignee: Bartlomiej Piotrowski (bpiotrowski) → Bogdan Dobrelya (bogdando)
Changed in fuel:
assignee: Bogdan Dobrelya (bogdando) → Bartlomiej Piotrowski (bpiotrowski)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-library (master)

Reviewed: https://review.openstack.org/156534
Committed: https://git.openstack.org/cgit/stackforge/fuel-library/commit/?id=9ff2b93194b41edb2c5de01440ff0b20018af1d0
Submitter: Jenkins
Branch: master

commit 9ff2b93194b41edb2c5de01440ff0b20018af1d0
Author: Bartłomiej Piotrowski <email address hidden>
Date: Tue Feb 17 11:30:17 2015 +0100

    Log slow and unindexed queries when debug is enabled

    Change-Id: Ic68eb94792366ccda1a7482f306337b667a59f69
    Closes-Bug: 1404171

Changed in fuel:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.