Hi,
I just found a really cool tool (mentioned in SysAdmin journal).
It shows a dynamic picture of MySQL processes just like 'top' (see
below).
MySQL on localhost (3.23.37) up 2+20:24:55 [09:12:03]
Queries Total: 543,555 Avg/Sec: 2.21 Slow: 1
Threads Total: 13 Active: 1 Cached: 0
Key Efficiency: 97.87% Bytes in: 186,667,281 Bytes out: 227,159,325
Id User Host DB Time Cmd Query or State
-- ---- ---- -- ---- --- ----------
16776 root localhost test 0 Query show full processlist
16749 search localhost search 1 Sleep
16745 search localhost search 2 Sleep
....
16746 search localhost search 19 Sleep
16752 search localhost search 19 Sleep
16763 search localhost search 23 Sleep
You can see what queries are taking too long and kill queries
interactively.
You can find it here: http://jeremy.zawodny.com/mysql/mytop
It would be great to have a similar tool for mod_perl/apache. You
could see the memory consumption of children over time, number of requests
served, average response time etc.
At the moment I end up repeatedly doing things like:
ps -aux | grep apache | wc -l
to see the number of children and then make guestimates of
average per child memory consumption.
Does anyone want to code this up over the weekend? ;-)
Nige
--
Nigel Hamilton
Turbo10 Metasearch Engine
email: [EMAIL PROTECTED]
tel: +44 (0) 207 987 5460
fax: +44 (0) 207 987 5468
________________________________________________________________________________
http://turbo10.com Search Deeper. Browse Faster.
