Any open source MySQL performance monitoring software?

Question

I am working on improving MySQL server performance. I am looking for something to monitor the performance of MySQL (as a query per second) over time, so that I can measure any improvements I make.

Are their easy to use open source programs that do this?

Thank.

Answer 1

I like the mytop tool . It’s just like topin the * nix world, but for MySQL itself. And that basically does exactly what you ask ...

, Apache Bench MySQL. , script, , , . AB concurrency. , , , , . , . , , . :

<?php
$my = new MySQLi($host, $user, $pass);
$my->query('SELECT foo');

, AB:

ab -c 10 -n 10000 http://localhost/path/to/my/test.php

, concurrency (-c 10), . , , , .

Answer 2

MySQL workbench .

http://wb.mysql.com/

Answer 3

, , . Percona innotop, mytop. InnoDB . CentOS, EPEL.