Automated SQL checker?

Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it could use some updating. Thanks

RE: Automated SQL checker?

t Subject: Automated SQL checker? Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it

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 information type, or is that a

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 ( o

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 I’m on shared hosting (unles