[TriLUG] MySQL strangeness

[Brian McCullough via TriLUG]

On Wed, Sep 02, 2015 at 10:18:02AM -0400, Triangle Linux Users Group discussion list wrote:
> 
> I found it off.  I turned it on for a minute or two, and got 191K of
> output before I turned it off again.
> 
> Already I see at least one table that is getting a lot of hits and only
> has the Primary Key, no extra indexes.

Just for fun, I added an index to one column in a Select that I was
seeing in the Slow Query log, and the Explain output went from 54,406
rows processed to 1!



B-)