Not sure if this helps, but we've had a situation like this, and the
cause was the network. We found that a query from the mysql client on
the machine was really fast, but from anywhere else it was slow. We
finally traced the problem down to a duplex conflict between the machine
and the swit
Thanks for the assistance!
> Seems hard to answer without asking more questions, but some
> basic questions first:
>
> Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews)
Yes, they are:
mysql> SHOW INDEX FROM aptreviews;
+++--+--+--
Seems hard to answer without asking more questions, but some
basic questions first:
Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews)
Have you tried EXPLAIN'ing the query to see if maybe the index
isn't being used?
Questions:
That the queries are stuck on 'Send
I am hosting websites that use the mysql database. One of my customers has
a query that they run occasionally that really bogs down the entire server.
The load sometimes jumps up into the double digits (on a Red Hat 6.2
server).
Here is their query:
select count(*) from aptreviews, aptcomplexes
