Performance tool for MySQL

Question

Ciao, I'm looking for performance tool for testing of load in terms of data and number of users,better if they are open source

Thanks

Andrea

Answer 1

Check Spotlight. It's have a powerful tool

and see this page it have a bunch of powerful tools

Answer 2

In linux: mytop

"mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL"

Ps: It's open source

Answer 3

I liked monyog though it was slightly buggy when it first got out of beta-testing.

Answer 4

For diagnose performance problems you can use free MySQL Query Profiler.