Brice Figureau <[email protected]> writes: > One thing I noticed is the following: I had in two separate places > (modules) the following pattern: > > if ! defined(File["a"]) { > file { "a": > ... > } > } > > Then when a host was coming to get its config in puppetmaster, it could > get the File[a] defined from place1. If it was connected to another > master process, then the same host could get the File[a] from place2. > It isn't an issue per se, but that means that this resource has possibly > too different tag set (one mentioning place1, the other place2). > So each time, the tags for this resource was deleted and recreated, > generating database load. > > Maybe you have such pattern in your manifests?
I don't think we have this. If we did wouldn't it be generating the extra load all the time instead of twice a month (our sample size is still just 2 so twice a month might not be quite right ) > But maybe the cause is external to MySQL. I have seen this kind of stuff > happen when: > * I/O degrades because another process is eating all the available > disks throughput (usually backup processes or snapshotting) > * I/O degrades because the machine is swapping (something eating > memory), either because the swap area is on the same disks as the mysql > data, or simply because mysql innodb buffer pool is being swapped in & > out. This box is dedicated to puppetmaster and MySQL and never has iowait so I don't think this is it. > What I suggest you is if it happens next time, is to use innotop and > have a look to the live running queries. You might find that you have > one or more "slow" queries. I installed innotop. Of course it says everything's bored right now :) I assume that when there's a slow query it sticks around on the screen? Everything's so fast now that it disappears before I can read the SQL. I also installed maatkit. Hopefully we'll learn something during the next storm! Thanks for the help! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en -~----------~----~----~----~------~----~------~--~---
