Hi,
> Am 03.09.2015 um 21:37 schrieb Thomas Gelf <thomas.g...@netways.de>: > > > >> Am 03.09.2015 um 20:35 schrieb Michael Friedrich: >>> Am 03.09.2015 um 15:51 schrieb Felix Cruz: >>> My request is simple - the general search field appears to be limited >>> to strings within the Service column. Is there a way to have it >>> search the Status Information field as well for a string or phrase. >> That would have a huge I/O and then cpu impact in order to grep in >> outputs reading the status file into memory. > > While I have to second Michael here... > >> That's neither possible with a database backend as used in Icinga Web*, >> as filtering on the output column being plenty of kilobytes without any >> index will certainly kill a web application's (asynchronous) request. > > ...I have to disagree with this statement. Filtering host/service lists > by output or even long output fields in Icinga Web 2 (IDO DB) works fine > and is very fast. A database doesn't get nervous if you attempt to > wildcard search on a text field without any index even if there are tens > of thousands of rows. Things start to get worse when millions of rows > are involved or when the schema forces you to do weird joins - what is > fortunately mostly not the case for simple host/service lists. Given the IDO schema you'll always have weird joins, either by some orm (doctrine in web1) or manually. My statement was merely meant for web1/2 and such feature requests. Guess web2 scales better but I only did some tests with web1 in the past years with that. Kind regards, Michael > > Cheers, > Thomas > > -- > Thomas Gelf > Principal Consultant > > NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg > Tel: +49 911 92885-0 | Fax: +49 911 92885-77 > GF: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 > http://www.netways.de | thomas.g...@netways.de > > ** OSBConf 2015 - September - osbconf.org ** > ** OSMC 2015 - November - netways.de/osmc ** > _______________________________________________ > icinga-users mailing list > icinga-users@lists.icinga.org > https://lists.icinga.org/mailman/listinfo/icinga-users -- Michael Friedrich, DI (FH) Senior Developer NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg Tel: +49 911 92885-0 | Fax: +49 911 92885-77 GF: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 http://www.netways.de | michael.friedr...@netways.de ** OSBConf 2015 - September - osbconf.org ** ** OSMC 2015 - November - netways.de/osmc ** _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
