Case-insensitive objects in NDOutils

Michael Friedrich michael.friedrich at
Tue Apr 20 16:12:48 CEST 2010

-------- Original Message  --------
Subject: Re: [Nagios-devel] Case-insensitive objects in NDOutils
From: Hendrik Baecker <andurin at>
To: nagios-devel at
Date: 2009-10-22 08:25
>>     ALTER TABLE nagios_objects MODIFY name1 varchar(128) COLLATE
>> latin1_bin NOT NULL default '';
>>     ALTER TABLE nagios_objects MODIFY name2 varchar(128) COLLATE
>> latin1_bin default NULL;
>> The code then stayed the same. Also it means anything trying to read the
>> data doesn't need to remember to specify BINARY either.

Just to mention - binary casts may slow down selects on large tables. 
There were reports in Icinga IDOUtils about that while changing the 
collation to case-sensitive will do the trick probably.

Besides there are several queries using SELECT * instead of SELECT 
tablename_id generating useless database traffic - two of those are just 
for checking if there's an entry or to fetch the object_id.

Another proposal - why not add several indexes from mysql-mods-*.sql 
directly into the DB default definition? This would resolve performance 
issues on SELECT/DELETE.

The other thing is the duplicated rows stuff. Much to do for NDOUtils 
1.5 :-)

Kind regards,

DI (FH) Michael Friedrich
michael.friedrich at
Tel: +43 1 4277 14359

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria

Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.

More information about the Developers mailing list