What are good Linux tool(s) for MySQL administration and profiling?

Question

While Windows releases of MySQL administration and profiling tools seem to be a dime a dozen, I'm having a very hard time finding very many designed for Linux.

Note that I'm not looking for monitoring software ala Nagios/Munin here. This would be something more along the lines of a SQLYog.

While I could write some basic scripts to handle most of the things I need from the CLI and do things through the mysql client console, are there any particularly good examples of good releases that do some or all of the following?

• Basic query profiling using EXPLAIN.
• Copy/diff of databases (some type of sync tool)
• Slightly more intuitive creation/editing/testing of triggers and stored procs

Knowing that many linux releases thrive on the "divide and conquer mentality", examples of tools that do ONE of the above very well would be of great help, too.

Answer 1

Take a look at Maatkit. It includes tools for synchronization of databases, more informative EXPLAINs, and a lot of other stuff. It's developed and supported by the same guys that wrote High Performance MySQL and that runs MySQL performance blog.

Answer 2

You might be interested in MySQL Workbench 5.2. As I recall it was also available for Linux. I use in Ubuntu ordinary phpMyAdmin, since I don't need such advanced tool there, but you might want to give it a try.