Basically, I'm looking for a free option to MySQL Query Analyzer.
I need a tool that can log all queries and analyze the performance of those queries (time, memory, affected rows, errors and things like these). I have a preference for a GUI tool like Query Analyzer, but fine with a command line tool also.
I intend to use it in a Windows Machine to monitoring a Ubuntu Server with MySQL 5.5.
Anyone knows some tool with these specification?
A previous comment (erased) in this question suggested the use of
EXPLAIN. I didn't know it, but I'll search for more information. If anyone know other tools, they are welcome.