Hi Thomas, Thank you for your response! I will look in to them as I have time and as I get my test/home lab setup, thank you for helping me understand the history. They are definitely good starting points to look in to performance issues.
I wanted to make sure I wasn't duplicating work in my free time if someone was already working on them more often. Thanks, Lee NB: Understood regarding schema/structure related changes, thank you for noting it On 01/23/2016 05:41 AM, Thomas Gelf wrote: > Hi Clemens, > > they have been assigned to me, but honestly I do not even remember why > that happened. I do not really feel responsible for them. I'm good at > troubleshooting, drilling down and figuring out bottlenecks. That's what > I did with those tickets nearly half a year ago. I had a look at query > performance and schema and created related issues, wherever I found > things that could be improved. > > There could be quite some quick wins I guess, but nothing happened since > them. If you want to steal them please feel free to do so, I do not work > as a developer and will probably be granted zero time to work on those > tasks. Eventually ask Michael or Gunnar first if it is OK for them, or > even simpler: start with a couple of pull requests referring to those > (or also newly created). If they look good I guess nobody will hinder > you from doing even more of the good work ;) > > Thanks, > Thomas > > NB: Please note that wee also support PostgreSQL. Tuning a MySQL index > without taking care of PostreSQL is fine, that's how it should be done. > Applying exactly the same Index to both of them is often a bad idea. But > as soon as your changes touch table structure your pull requests must > also take care of PostgreSQL. > > Am 23.01.2016 um 05:04 schrieb Lee Clemens: >> Hello, >> >> There are several subtasks under Enhance DB IDO performance, >> https://dev.icinga.org/issues/10073 >> >> Most of them show as Assigned. Are the assignees actively working on them? >> >> While I haven't worked with C++ in a while, I have always been interested in >> MySQL - so my experience regarding MySQL tuning/performance plus general >> development experience may be valuable :) I'm taking a closer look at my own >> installation, but I guess I'm hoping to for help being pointed in a >> direction towards what I can help with in the base code. >> >> Any advice is greatly appreciated. >> >> Thanks, >> Lee Clemens >> _______________________________________________ >> icinga-users mailing list >> icinga-users@lists.icinga.org >> https://lists.icinga.org/mailman/listinfo/icinga-users >> > > -- > Thomas Gelf > Principal Consultant > > NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg > Tel: +49 911 92885-0 | Fax: +49 911 92885-77 > CEO: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 > http://www.netways.de | thomas.g...@netways.de > > ** OSDC 2016 - April - netways.de/osdc ** > ** OSBConf 2016 - September - osbconf.org ** > _______________________________________________ > icinga-users mailing list > icinga-users@lists.icinga.org > https://lists.icinga.org/mailman/listinfo/icinga-users > _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
