Project

General

Profile

Bug #2489

investigate mysql joins

Added by kclair about 7 years ago.

Status:
New
Priority:
High
Assignee:
-
Category:
-
Target version:
-
Start date:
08/30/2010
Due date:
% Done:

0%

QA Check:
Feature Branch:

Description

from we.riseup.net:

JOINS
Current join_buffer_size = 132.00 K
You have had 1113 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.

Also available in: Atom PDF