[BBLISA] MySQL performance tools

[John P. Rouillard]

In message <20074.27257.978339.844961 at quad.stoffel.home>,
"John Stoffel" writes:
>tom> I am looking for MySQL performance tools and monitors.  Any
>tom> recommendations would be appreciated.
>
>tom> using MySQL 5.0 with MyISAM tables on Ubuntu and mysql 5.1 on XP
>
>I've been down this path too, esp since I'm not a mysql admin in real
>life.  I found that the following to be helpful:
>
>  mysqlreport
>  mysqlsla-2.03
>
>and of course looking at the slow queries log.  

Also have you looked at mysqltuner and sheeri cabral's updates to it?

Sheeri Cabral was our Oct 2010 speaker on Using MySQLtuner 2.0 to
monitor and improve mysql performance

Her slides are at: http://www.bblisa.org/slides/2010_10_mysqltuner.pdf

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.