[mdlug] Any MySQL gurus out there

[Brian Brodsky]

Matthew,

Chances are you do not have indexes setup that you need. Also if you 
cannot determine indexes needed just by looking at query did you try an 
EXPLAIN?

Brian

On 09/12/2014 11:33 AM, Mathew May wrote:
> Are there any MySQL gurus that are going to be at the meeting this weekend? I have an issue at work where a query that takes less than 3 minutes to run in the dev environment, yet takes over 30 minutes to run in the qa environment.
>
> I only have two days of MySQL experience and was looking for someone who might be able to point me in some kind of direction.
>
> Both servers are the same hardware and configuration wise so I know that it is not a hardware / OS issue.
>
> All I know is my head hurt from reading so much and getting no where.
> _______________________________________________
> mdlug mailing list
> mdlug at mdlug.org
> http://mdlug.org/mailman/listinfo/mdlug