phpmyadmin Question posted in
The official documentation can be found here.

get MySQL query list of joins that do not use indexes – Phpmyadmin

I see this error in phpmyadmin:

The number of joins that do not use indexes

but I never use join in my code.

Now I want get a list of query that do not use indexes.

How can I get this list?

I tried enabling slow query log, but I can not understand which query is not use indexes.

Can someone guide me?

Tags:

2

Answers


  1. 0

    There is no list of "joins not using indexes".

    Certain admin queries use VIEWs that have JOINs; possibly that is where they came from.

    There are valid cases in which not using an index is OK for a JOIN. A simple example is joining two tables where one of the tables has so few rows that an index would not help with performance.

    The slowlog provides something more important — a list of the "worst" queries (from a performance point of view). Any "slow" query with JOIN that needs an index will show up, even without that setting turned on. (I prefer to turn off that option, since it clutters the slowlog with unexciting queries.)

    Login or Signup to reply.
  2. 0

    I’ll briefly mention that this isn’t an error, it’s not even really a warning. The Advisor tab is meant to make broad and generic performance suggestions that are meant to guide you towards optimizing your system. Having some of these suggestions that aren’t fixable or don’t apply to your situation is pretty normal. In fact, my test system gives the same advice about the join without an index.

    As Rick James alluded to, these queries might not come directly from code that you write…some administrative tasks may be triggering it (your operating system might run some housekeeping queries, MySQL runs some queries against itself, etc).

    The best way to look at the queries is to log them, which is answered in Log all queries in mysql. You could use the "Process" sub tab of the "Status" area in phpMyAdmin (very similar to how you get to the Advisor tab) to look at active queries, but that’s not going to give you a complete picture over time. Once you have that list of queries, you can analyze them to determine if there are improvements you can make to the code.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search