Re: MySQL / SNMP (revised)

[Michel Stam]

No problem, Stewart, take your time.

I'm still thinking of ways to improve the code (which is basically also 
limited by the time I can spend on it).
Something thats been on my mind is improving speed by having one or two 
threads retrieve the data for the tables into memory periodically, so 
SNMP queries can be served instantly. This should also significantly 
reduce the number of times MySQL is bothered by the agent.
I'll have to look into the threading as MySQL provides it, I saw MySQL 
has a few wrapper functions for it.

Cheers,

Michel

Stewart Smith wrote:
> On Tue, 2006-08-15 at 12:07 +0200, Michel Stam wrote:
>   
>> Slight update;
>>
>> I had a talk with Steve Corey about the MySQL enterprise OID to be used 
>> - As the enterprise OID is partly used by MySQL I was asked to use 
>> .1.3.6.1.4.1.24993.42 as the base of the SNMP tree. I've made a change 
>> to the code to reflect this (common.h and the MYSQL-DB-MIB.mib file).
>>
>> As always available at http://www.reverze.net/mysql_snmp.tar.gz
>>
>> If possible, is there someone who is willing to help me test this module 
>> on a large database? Most testing has been done on very small databases, 
>> and I'd like to know how it performs.
>>     
>
> I've been meaning to take a closer look (as opposed to my general quick
> look before) for a little while.
>
> I've just been travelling like mad so it's slipped down the list of
> urgent things to do.
>
> However, it's still on my list.
>