On 22/02/09 13:51, Peter Meier wrote: > Hi > >> Here is the second version of my patch to improve storeconfigs performance, >> in the case of no modifications (ie the manifests don't change between >> runs) >> >> [...] >> Please review, comment and test :-) > > sometimes pictures tell more than words and numbers: > > https://durito.cronopios.org/mysql_queries-day_storeconfigs_speedup_v2.png > > unfortunately the picture needs some explanation: > > from the left up to ~1PM (13:00) master was running with 0.24.7. then it > have been offline a while (~2 hours). after getting back around 4PM > (16:00) it have been updated against latest HEAD of 0.24.x. so the > following (nearly invisible) peaks are counting. awesome! thanks a lot! > > then around 00:00 I started debugging and testing fixes for #2004 which > all broke it against and were not what I expected and then I forgot to > revert them. this is why we have the ugly peaks there. > I reverted them now and the mysql usage is again the same as after 4PM > (16:00). > > I would say usage dropped to a fith or tenth of what we had before! :)
It's pleasant to see that it works fine. Yhat's also the numbers I observed on my mysql server. I think this is a good path toward more sustainable storeconfigs (until Puppet moves to a specific/different storage system). Thanks for testing Peter, -- Brice Figureau Days of Wonder http://www.daysofwonder.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Developers" group. To post to this group, send email to puppet-dev@googlegroups.com To unsubscribe from this group, send email to puppet-dev+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/puppet-dev?hl=en -~----------~----~----~----~------~----~------~--~---
