session lock problem

@makif,

If queries are taking a long time then we need to look at whether or not the used tables need indexes. What queries are taking a long time to execute? Can you run an Explain on them?

@makif,

If queries are taking a long time then we need to look at whether or not the used tables need indexes.  What queries are taking a long time to execute? Can you run an Explain on them?

for example count queries takes long time, query has joins and where and it locked all sessions.
and i check explaion other queries

@makif,

Can you show us examples of the queries that are running long? What tables are being used in the queries? What information did the explain give you on the queries?

@makif,

Can you show us examples of the queries that are running long?  What tables are being used in the queries?  What information did the explain give you on the queries?

t1 table has 22 millions rows

Code:

EXPLAIN
SELECT COUNT(1) AS total
FROM t1 p FORCE INDEX (PRIMARY)
INNER JOIN t2 e ON p.c2= e.c1
WHERE `e`.`Type` IN ("PARKINGLOT","PARKINGVIOLATION","REDLIGHTVIOLATION","FORBIDDENTURN","ALPR","EMBEDDEDALPR","SECTIONSPEED","SENSOR_REDLIGHT","SENSOR_SPEED")

explanation show me, p not use key

@makif,

Does the t1 table have indexes? if so, what are they?

@makif,

Does the t1 table have indexes?  if so, what are they?

yes t1 has many indexes. especially prımary, also unique index, t1 has indexes which can searchable

@makif,

What about t2?

When you ran the explain feature what was the output?

@makif,

What about t2?

When you ran the explain feature what was the output?

t2 show me its key area is  PRIMARY, but t2 has just max 100-200 rows, and also  t2 has the keys for searchable

@makif,

How long does it take for the query to run?

@makif,

How long does it take for the query to run?

it takes more than a minute and it locked all session again.
does it suppose to lock just session which send request?  or am i wrong