Friday, 2015-04-17

*** ZZelle_ has quit IRC00:04
*** ericpeterson has joined #openstack-dns00:09
*** nkinder has joined #openstack-dns00:14
*** ericpeterson has quit IRC00:19
*** mwagner_lap has joined #openstack-dns01:00
*** nkinder has quit IRC01:05
*** GonZo2K has joined #openstack-dns01:13
*** stanzgy has joined #openstack-dns01:35
*** jmcbride has joined #openstack-dns01:47
*** nkinder has joined #openstack-dns01:49
*** MentalRay has joined #openstack-dns02:03
*** nkinder has quit IRC02:24
*** ericpeterson has joined #openstack-dns02:30
*** GonZo2K has quit IRC02:35
*** GonZo2K has joined #openstack-dns02:36
*** GonZo2K has quit IRC02:37
*** nkinder has joined #openstack-dns03:00
*** ericpeterson has quit IRC03:08
*** jmcbride has quit IRC03:08
*** richm has quit IRC03:17
*** nkinder has quit IRC03:18
*** crc32 has joined #openstack-dns03:20
*** ericpeterson has joined #openstack-dns03:38
*** ericpeterson has quit IRC03:39
*** km has joined #openstack-dns04:01
*** nkinder has joined #openstack-dns04:32
*** crc32 has quit IRC04:38
*** crc32 has joined #openstack-dns04:38
*** crc32 has quit IRC04:45
*** crc32 has joined #openstack-dns05:15
*** openstackgerrit has quit IRC05:21
*** openstackgerrit has joined #openstack-dns05:21
*** ChanServ sets mode: +v openstackgerrit05:21
*** MentalRay has quit IRC05:38
*** clayton has quit IRC07:17
*** dvorak has joined #openstack-dns07:18
*** chlong has quit IRC07:33
stanzgymugsie: for the pdns mysql problem mentioned yesterday, I discussed with Habbie on #powerdns@OFTC . His option is that pDNS is designed to work in that way and suggest to do some mysql tuning to solve this problem.08:10
stanzgythe powerdns community mostly will not fix this in future.08:10
*** crc32 has quit IRC08:23
mugsie:(08:32
*** c0m0 has joined #openstack-dns08:35
mugsiestanzgy: ok, let me double check next early week with a 65k zone08:35
*** jordanP has joined #openstack-dns08:42
ahu_stanzgy: any idea how we even COULD fix the issue of commits being slow on your system?09:55
ahu_I'm at a loss what you expect from us09:55
ahu_"not use commits09:56
ahu_"?09:56
mugsieahu_: batching the inserts would be a good first step (not for the commits, but to reduce latency in general)09:56
mugsieso DELETE blah; INSERT INTO blah, ($values),($values2); etc09:56
ahu_ok, but that's another problem, right?09:57
mugsieyeah09:57
mugsiethe answer is "tune the db"09:57
mugsiefrom what I can see09:57
mugsieunless pdns wants to do a compare in memory and write the diff09:58
ahu_well the answer is "don't fix the problem of the database elsewhere"09:58
*** jmcbride has joined #openstack-dns09:59
ahu_mugsie, we can't even calculate the diff w/o locking the database etc10:00
ahu_not sure if this would actually help you10:00
*** jmcbride has quit IRC10:00
mugsiewell, it would help the size of the commit, at the cost of concurrecny10:01
*** untriaged-bot has joined #openstack-dns10:01
untriaged-botUntriaged bugs so far:10:01
untriaged-bothttps://bugs.launchpad.net/designate/+bug/144512710:01
openstackLaunchpad bug 1445127 in Designate "Multiple Pool Manager - every PM is running periodic sync" [Undecided,Confirmed]10:01
untriaged-bothttps://bugs.launchpad.net/designate/+bug/144490110:01
openstackLaunchpad bug 1444901 in Designate "Service threadpool size needs to be configurable" [Undecided,Triaged]10:01
*** untriaged-bot has quit IRC10:01
*** jmcbride has joined #openstack-dns10:01
stanzgyahu_: maybe cache latest version of zone records data in memory and compare it with incoming AXFR to do a *incremental* sync would work. But I know it's expensive and very hard to implement, so I'm just trying to tune mysql for better performance now.10:36
ahu_ok, good luck!10:36
stanzgyahu_: I would also be grateful if you could offer some better solutions to improve this situation since I'm new to powerdns not familiar with its tuning.10:37
stanzgyahu_: ;D10:37
ahu_we have a my.cnf we recommend, hold on10:38
stanzgyahu_: okay, many thanks10:38
*** eandersson has quit IRC10:39
stanzgyahu_: Sorry that I need to catch the last bus to go home now, you can post to stanzgy_ and I will check it tomorrow. Thanks for your help.10:51
*** stanzgy has quit IRC10:56
*** km has quit IRC11:00
*** mwagner_lap has quit IRC11:26
*** jmcbride has quit IRC12:00
*** jmcbride has joined #openstack-dns12:05
*** ericpeterson has joined #openstack-dns12:10
*** mwagner_lap has joined #openstack-dns12:19
*** dvorak is now known as clayton12:25
*** ericpeterson has quit IRC12:32
*** c0m0 has quit IRC13:07
*** richm has joined #openstack-dns13:09
*** kei_yama has quit IRC13:13
*** andrewbogott_afk is now known as andrewbogott13:19
*** busterswt has joined #openstack-dns13:33
*** busterswt has quit IRC13:39
*** busterswt has joined #openstack-dns13:39
*** jmcbride has quit IRC13:50
*** jmcbride has joined #openstack-dns13:50
*** vinod1 has joined #openstack-dns13:56
*** busterswt has quit IRC14:03
*** EricGonczer_ has joined #openstack-dns14:05
*** ericpeterson has joined #openstack-dns14:10
*** mwagner_lap has quit IRC14:29
*** paul_glass has joined #openstack-dns14:35
*** MentalRay has joined #openstack-dns14:46
*** MentalRay has quit IRC15:03
*** MentalRay has joined #openstack-dns15:10
*** ZZelle has quit IRC15:25
*** ZZelle has joined #openstack-dns15:26
*** EricGonczer_ has quit IRC15:38
*** EricGonczer_ has joined #openstack-dns15:43
*** kbyrne has quit IRC16:00
*** untriaged-bot has joined #openstack-dns16:01
untriaged-botUntriaged bugs so far:16:01
untriaged-bothttps://bugs.launchpad.net/designate/+bug/144512716:01
openstackLaunchpad bug 1445127 in Designate "Multiple Pool Manager - every PM is running periodic sync" [Undecided,Confirmed]16:01
untriaged-bothttps://bugs.launchpad.net/designate/+bug/144490116:01
openstackLaunchpad bug 1444901 in Designate "Service threadpool size needs to be configurable" [Undecided,Triaged]16:01
*** untriaged-bot has quit IRC16:01
*** paul_glass has quit IRC16:17
*** MentalRay has quit IRC16:58
*** MentalRay has joined #openstack-dns16:58
*** jordanP has quit IRC17:43
*** ZZelle_ has joined #openstack-dns18:11
ZZelle_mugsie, hi18:11
*** EricGonc_ has joined #openstack-dns18:14
*** EricGonczer_ has quit IRC18:17
*** vinod1 has quit IRC18:24
*** vinod1 has joined #openstack-dns18:25
*** vinod1 has quit IRC18:30
*** vinod1 has joined #openstack-dns18:30
*** EricGonc_ has quit IRC19:07
*** EricGonczer_ has joined #openstack-dns19:08
ahu_https://www.monshouwer.eu/paste/9bd24qfrp1yrvcr3 <- good start for your mysql config for powerdns19:17
*** jmcbride has quit IRC19:24
*** andrewbogott is now known as andrewbogott_afk19:30
*** andrewbogott_afk is now known as andrewbogott19:56
*** paul_glass has joined #openstack-dns20:03
openstackgerritEric Peterson proposed openstack/designate: Add policy support to designatedashboard  https://review.openstack.org/16910620:22
*** openstackgerrit has quit IRC20:22
*** openstackgerrit has joined #openstack-dns20:22
*** ChanServ sets mode: +v openstackgerrit20:22
ericpetersonrebasing horizon changes , no new changes.... ready for another +220:22
openstackgerritEric Peterson proposed openstack/designate: Correct designate-dashboard domain detail screen  https://review.openstack.org/17307920:23
ZZelle_Hi everyone20:43
ZZelle_is it normal to get "pegasus.theresis.org.1INSOAns1.devstack.org. pegasus.theresis.org. 1429297339 3600 600 86400 3600" when pegasus.theresis.org. domain ttl is 900?20:44
*** logan2 has quit IRC20:59
*** logan2 has joined #openstack-dns21:00
-openstackstatus- NOTICE: Gerrit will be unavailable between 22:00 and 23:59 UTC for project renames and a database update.21:04
*** EricGonczer_ has quit IRC21:17
*** ericpeterson has quit IRC21:22
*** openstackgerrit has quit IRC21:23
*** openstackgerrit has joined #openstack-dns21:23
*** ChanServ sets mode: +v openstackgerrit21:23
*** vinod1 has quit IRC21:55
*** paul_glass has quit IRC21:58
-openstackstatus- NOTICE: Gerrit is unavailable until 23:59 UTC for project renames and a database update.22:04
-openstackstatus- NOTICE: Gerrit is unavailable until 23:59 UTC for project renames and a database update.22:07
*** ChanServ changes topic to "Gerrit is unavailable until 23:59 UTC for project renames and a database update."22:07
*** MentalRay has quit IRC22:22
*** andrewbogott is now known as andrewbogott_afk22:32
*** EricGonczer_ has joined #openstack-dns22:35
*** EricGonczer_ has quit IRC22:36
*** EricGonczer_ has joined #openstack-dns22:37
*** EricGonczer_ has quit IRC22:38
*** andrewbogott_afk is now known as andrewbogott22:43
*** ericpeterson has joined #openstack-dns22:51
*** ericpeterson has quit IRC22:52
*** EricGonczer_ has joined #openstack-dns22:54
*** ChanServ changes topic to "OpenStack Designate - Logged @ http://eavesdrop.openstack.org/irclogs/%23openstack-dns"23:04
-openstackstatus- NOTICE: Gerrit is available again.23:04
*** andrewbogott is now known as andrewbogott_afk23:28

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!