Re: Automated SQL checker?

> On Apr 12, 2017, at 3:38 PM, Ronan McGlue wrote: > > Enable the slow log on the DB. Thanks Ronan. That sounds like it would be beneficial. I take it you’re referring to a setting on the server, though. If that’s the case, I don’t think I can do that as

Re: Automated SQL checker?

Hi Frank, Enable the slow log on the DB. Any queries which are above the threshold variable ( |long_query_time| ) will be logged . Default is 10s, so I assume you'd want to drop this down to 1-2 (

Re: Automated SQL checker?

> On Apr 11, 2017, at 1:26 PM, Michael Munger > wrote: > > Use MySQL workbench. Thanks, Michael. I played with it some already and it looks like it will give me a lot to work with. Will it also let me know if field types are wrong for the given

RE: Automated SQL checker?

Use MySQL workbench. Add query to the editor, execute, check results. Then, use the "Execution plan" feature to see how things are executing and look for bad things (Cartesian products, stupid loops, etc...) See also: Query stats. Michael Munger, dCAP, MCPS, MCNPS, MBSS High Powered Help,