2

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?

UPDATE

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.

3

The one that I know is TOra, which seems to do what you ask for (and much more).

TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.

In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.

Here are a few screenshots that could be relevant to you, it's and old version of the program, but you get the idea:

TOra trace TOra stat manager TOra session

  • I'll test it, but apparently it's perfect! Thx! – James May 31 '15 at 20:14
  • 1
    Thanks for this!! It does, indeed, look excellent. Very powerful & feature filled. I was impressed by the quote by the guy from Red Hat who said "It's licensed under the GPL and it's functionality meets or exceeds the abilities of any proprietary application we've seen". – Mawg Jun 2 '15 at 9:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.