Announcement

Announcement Module
Collapse
No announcement yet.

Query Showing in LOG_QUERIES_WITHOUT_INDEXES Why?

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

  • Query Showing in LOG_QUERIES_WITHOUT_INDEXES Why?

    I have this query:

    SELECT
    `guild_areas`.`name`,
    `guild_areas`.`show_name`,
    `guild_areas`.`description`,
    `guild_areas`.`area_id`,
    `guild_area_config`.`guild_id`,
    `guild_area_config`.`active`
    FROM
    `guild_area_config`
    Join
    `guild_areas` ON `guild_area_config`.`area_id` = `guild_areas`.`area_id`
    and guild_areas.show_content_option = 0
    and `guild_area_config`.`guild_id` = 35290
    and guild_areas.show_content_option=0
    order by
    `guild_areas`.`area_id`;

    Which shows this EXPLAIN:


    id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE guild_areas index PRIMARY,idx_covering PRIMARY 1 NULL 16 Using where 1 SIMPLE guild_area_config eq_ref PRIMARY,idx_guild,idx_area PRIMARY 5 guild_areas.area_id,const 1


    Incidentally, the query returns 9 rows. guild_areas should only match once per row in guild_are_config, so the 16 is already a bit of an oddity.

    describe guild_areas; shows this


    Field Type Null Key Default Extra area_id tinyint(4) NO PRI NULL auto_increment name varchar(25) NO MUL show_name varchar(50) YES NULL description varchar(200) YES NULL show_auth tinyint(1) NO show_content_option tinyint(1) NO 0 is_admin_auth tinyint(4) NO 0 is_widget tinyint(4) NO 0


    describe guild_area_config; shows this


    Field Type Null Key Default Extra guild_id int(11) NO PRI area_id tinyint(4) NO PRI active binary(255) NO


    Anyone have any idea why this query shows up in the LOG_QUERIES_WITHOUT_INDEX log? The explain seems to show it using indexes.
Working...
X