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