[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [hobbit] - MySQL monitoring
- To: hobbit (at) hswn.dk
- Subject: Re: [hobbit] - MySQL monitoring
- From: "Matthew Davis" <matthew (at) familycampground.org>
- Date: Tue, 10 Oct 2006 12:43:29 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=XMkHMRi/b3GbYikRfx4006OzUFdGk68dFk7/sq3ZcAGQ65xASX3lDzqoG7WAw6pLRg01f2WNgcSFf9CZGPzxReFhfUkKtUAcvIdqxt2EUPNbt5bZtl5ljGRGh3XZyWT0vA/6RPs617LCtcQ56YKfNQsAJJxmx1cgTbASXvgCUKg=
- References: <452B9DA4.2010200@unil.ch> <OFFFCAF638.AD3B82F6-ONC1257203.0051FA12-C1257203.00533F29@cnp.fr>
On 10/10/06, thomas.seglard.enata (at) cnp.fr <thomas.seglard.enata (at) cnp.fr> wrote:
I'm just asking you how do you monitor your MySQL databases ? I've setted
Attached is a script I wrote up one night based off MySQL Activity
Report (http://gert.sos.be/en/projects/mysqlar/). Can't guarantee
it'll work, but it works for me with 4.1.21.
It does the following:
- max connections vs threads connected
- (Questions / Selects / Inserts / Updates / Deletes) per minute
- Table Cache vs Open Tables
- Created Tmp Tables vs Tmp Disk Tables <-- logic is wrong here I
know I need to fix this
It was my 2nd hobbit script, so please let me know where I can improve.
--
Matthew Davis
http://familycampground.org/matthew/