monitoring mysql

so it looks like the bottleneck for most indymedia installations is mysql. the mtop tool might be useful for determining when its neccessary to switch over to more static content or to do some kind of cacheing.

http://mtop.sourceforge.net/

this article seems helpful too:

http://www.mysql.com/news-and-events/newsletter/2004-01/a0000000301.html