The Slow Queries. To find the slow queries well need to log them either from Solr or from the application that queries it. Chances are the query is on that component somewhere.
The first step in dealing with slow queries is identifying which query is actually running slowly. Slow Query Log Overview. A good script i found a while ago on SQL server performance will help get you started.
This table stores all the slow queries in the instance.
The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. Use the command mysqldumpslow to analyze it and print summary of the slow query logfile. In the slow queries section a list of queries is displayed in the left hand side table. The slow query log will track single queries.