Also, have some munin plugins. There are the ones I add to the ones in a standard munin distribution, and give plenty of info.
Only the mysql_ one is actually mine, I got the rest off muninexchange. Guess I should incorporate their functionality into mine sometime. A good look at the data that comes out of these (and an understanding of how MySQL works, of course) will tell you what's up, what's happened and where to tune. On Thu, Apr 22, 2010 at 9:12 AM, Johan De Meersman <vegiv...@tuxera.be>wrote: > > On Wed, Apr 21, 2010 at 4:52 PM, shamu...@gmail.com <shamu...@gmail.com>wrote: > >> replacement etc, but that costs me too much if I can use hardware to solve >> the same problem. and Yes I know I will run to same problem again when the >> > > It may be that you can't actually solve it with more hardware. The version > of drupal we were using (we've built a highly customised one by now) had the > annoying tendency to explicitly lock tables, even when not strictly > necessary. A lock is a lock, regardless of how much hardware you throw > against it. > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org