GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

help identifying select_full_join queries

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • help identifying select_full_join queries

    I need some ideas for identifying select_full_join queries. On our production server cluster we have noticed a drop in performance and are trying to figure out whats going on. Noticed a very high about of select_full_join and would like to start by sorting that problem.

    Does anyone have any suggestions for figuring out where these queries are?


    +-----------------------------------+-------------+
    | Variable_name | Value |
    +-----------------------------------+-------------+
    | Aborted_clients | 89500 |
    | Questions | 1025703485 |
    | Handler_commit | 43239241 |
    | Handler_delete | 7664344 |
    | Handler_discover | 0 |
    | Handler_prepare | 11947144 |
    | Handler_read_first | 17393550 |
    | Handler_read_key | 1397203118 |
    | Handler_read_next | 143662626 |
    | Handler_read_prev | 242775284 |
    | Handler_read_rnd | 1219807251 |
    | Handler_read_rnd_next | 178486494 |
    | Handler_rollback | 7727 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 893976487 |
    | Handler_write | 2941955006 |
    | Open_tables | 512 |
    | Select_full_join | 6364004 |
    | Select_scan | 46452541 |
    | Slow_queries | 1227 |
    | Threads_created | 9125169 |
    +-----------------------------------+-------------+

    Thanks for any suggestions
Working...
X