*** ZZelle_ has quit IRC | 00:04 | |
*** ericpeterson has joined #openstack-dns | 00:09 | |
*** nkinder has joined #openstack-dns | 00:14 | |
*** ericpeterson has quit IRC | 00:19 | |
*** mwagner_lap has joined #openstack-dns | 01:00 | |
*** nkinder has quit IRC | 01:05 | |
*** GonZo2K has joined #openstack-dns | 01:13 | |
*** stanzgy has joined #openstack-dns | 01:35 | |
*** jmcbride has joined #openstack-dns | 01:47 | |
*** nkinder has joined #openstack-dns | 01:49 | |
*** MentalRay has joined #openstack-dns | 02:03 | |
*** nkinder has quit IRC | 02:24 | |
*** ericpeterson has joined #openstack-dns | 02:30 | |
*** GonZo2K has quit IRC | 02:35 | |
*** GonZo2K has joined #openstack-dns | 02:36 | |
*** GonZo2K has quit IRC | 02:37 | |
*** nkinder has joined #openstack-dns | 03:00 | |
*** ericpeterson has quit IRC | 03:08 | |
*** jmcbride has quit IRC | 03:08 | |
*** richm has quit IRC | 03:17 | |
*** nkinder has quit IRC | 03:18 | |
*** crc32 has joined #openstack-dns | 03:20 | |
*** ericpeterson has joined #openstack-dns | 03:38 | |
*** ericpeterson has quit IRC | 03:39 | |
*** km has joined #openstack-dns | 04:01 | |
*** nkinder has joined #openstack-dns | 04:32 | |
*** crc32 has quit IRC | 04:38 | |
*** crc32 has joined #openstack-dns | 04:38 | |
*** crc32 has quit IRC | 04:45 | |
*** crc32 has joined #openstack-dns | 05:15 | |
*** openstackgerrit has quit IRC | 05:21 | |
*** openstackgerrit has joined #openstack-dns | 05:21 | |
*** ChanServ sets mode: +v openstackgerrit | 05:21 | |
*** MentalRay has quit IRC | 05:38 | |
*** clayton has quit IRC | 07:17 | |
*** dvorak has joined #openstack-dns | 07:18 | |
*** chlong has quit IRC | 07:33 | |
stanzgy | mugsie: 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 |
---|---|---|
stanzgy | the powerdns community mostly will not fix this in future. | 08:10 |
*** crc32 has quit IRC | 08:23 | |
mugsie | :( | 08:32 |
*** c0m0 has joined #openstack-dns | 08:35 | |
mugsie | stanzgy: ok, let me double check next early week with a 65k zone | 08:35 |
*** jordanP has joined #openstack-dns | 08: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 us | 09:55 |
ahu_ | "not use commits | 09:56 |
ahu_ | "? | 09:56 |
mugsie | ahu_: batching the inserts would be a good first step (not for the commits, but to reduce latency in general) | 09:56 |
mugsie | so DELETE blah; INSERT INTO blah, ($values),($values2); etc | 09:56 |
ahu_ | ok, but that's another problem, right? | 09:57 |
mugsie | yeah | 09:57 |
mugsie | the answer is "tune the db" | 09:57 |
mugsie | from what I can see | 09:57 |
mugsie | unless pdns wants to do a compare in memory and write the diff | 09:58 |
ahu_ | well the answer is "don't fix the problem of the database elsewhere" | 09:58 |
*** jmcbride has joined #openstack-dns | 09:59 | |
ahu_ | mugsie, we can't even calculate the diff w/o locking the database etc | 10:00 |
ahu_ | not sure if this would actually help you | 10:00 |
*** jmcbride has quit IRC | 10:00 | |
mugsie | well, it would help the size of the commit, at the cost of concurrecny | 10:01 |
*** untriaged-bot has joined #openstack-dns | 10:01 | |
untriaged-bot | Untriaged bugs so far: | 10:01 |
untriaged-bot | https://bugs.launchpad.net/designate/+bug/1445127 | 10:01 |
openstack | Launchpad bug 1445127 in Designate "Multiple Pool Manager - every PM is running periodic sync" [Undecided,Confirmed] | 10:01 |
untriaged-bot | https://bugs.launchpad.net/designate/+bug/1444901 | 10:01 |
openstack | Launchpad bug 1444901 in Designate "Service threadpool size needs to be configurable" [Undecided,Triaged] | 10:01 |
*** untriaged-bot has quit IRC | 10:01 | |
*** jmcbride has joined #openstack-dns | 10:01 | |
stanzgy | ahu_: 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 |
stanzgy | ahu_: 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 |
stanzgy | ahu_: ;D | 10:37 |
ahu_ | we have a my.cnf we recommend, hold on | 10:38 |
stanzgy | ahu_: okay, many thanks | 10:38 |
*** eandersson has quit IRC | 10:39 | |
stanzgy | ahu_: 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 IRC | 10:56 | |
*** km has quit IRC | 11:00 | |
*** mwagner_lap has quit IRC | 11:26 | |
*** jmcbride has quit IRC | 12:00 | |
*** jmcbride has joined #openstack-dns | 12:05 | |
*** ericpeterson has joined #openstack-dns | 12:10 | |
*** mwagner_lap has joined #openstack-dns | 12:19 | |
*** dvorak is now known as clayton | 12:25 | |
*** ericpeterson has quit IRC | 12:32 | |
*** c0m0 has quit IRC | 13:07 | |
*** richm has joined #openstack-dns | 13:09 | |
*** kei_yama has quit IRC | 13:13 | |
*** andrewbogott_afk is now known as andrewbogott | 13:19 | |
*** busterswt has joined #openstack-dns | 13:33 | |
*** busterswt has quit IRC | 13:39 | |
*** busterswt has joined #openstack-dns | 13:39 | |
*** jmcbride has quit IRC | 13:50 | |
*** jmcbride has joined #openstack-dns | 13:50 | |
*** vinod1 has joined #openstack-dns | 13:56 | |
*** busterswt has quit IRC | 14:03 | |
*** EricGonczer_ has joined #openstack-dns | 14:05 | |
*** ericpeterson has joined #openstack-dns | 14:10 | |
*** mwagner_lap has quit IRC | 14:29 | |
*** paul_glass has joined #openstack-dns | 14:35 | |
*** MentalRay has joined #openstack-dns | 14:46 | |
*** MentalRay has quit IRC | 15:03 | |
*** MentalRay has joined #openstack-dns | 15:10 | |
*** ZZelle has quit IRC | 15:25 | |
*** ZZelle has joined #openstack-dns | 15:26 | |
*** EricGonczer_ has quit IRC | 15:38 | |
*** EricGonczer_ has joined #openstack-dns | 15:43 | |
*** kbyrne has quit IRC | 16:00 | |
*** untriaged-bot has joined #openstack-dns | 16:01 | |
untriaged-bot | Untriaged bugs so far: | 16:01 |
untriaged-bot | https://bugs.launchpad.net/designate/+bug/1445127 | 16:01 |
openstack | Launchpad bug 1445127 in Designate "Multiple Pool Manager - every PM is running periodic sync" [Undecided,Confirmed] | 16:01 |
untriaged-bot | https://bugs.launchpad.net/designate/+bug/1444901 | 16:01 |
openstack | Launchpad bug 1444901 in Designate "Service threadpool size needs to be configurable" [Undecided,Triaged] | 16:01 |
*** untriaged-bot has quit IRC | 16:01 | |
*** paul_glass has quit IRC | 16:17 | |
*** MentalRay has quit IRC | 16:58 | |
*** MentalRay has joined #openstack-dns | 16:58 | |
*** jordanP has quit IRC | 17:43 | |
*** ZZelle_ has joined #openstack-dns | 18:11 | |
ZZelle_ | mugsie, hi | 18:11 |
*** EricGonc_ has joined #openstack-dns | 18:14 | |
*** EricGonczer_ has quit IRC | 18:17 | |
*** vinod1 has quit IRC | 18:24 | |
*** vinod1 has joined #openstack-dns | 18:25 | |
*** vinod1 has quit IRC | 18:30 | |
*** vinod1 has joined #openstack-dns | 18:30 | |
*** EricGonc_ has quit IRC | 19:07 | |
*** EricGonczer_ has joined #openstack-dns | 19:08 | |
ahu_ | https://www.monshouwer.eu/paste/9bd24qfrp1yrvcr3 <- good start for your mysql config for powerdns | 19:17 |
*** jmcbride has quit IRC | 19:24 | |
*** andrewbogott is now known as andrewbogott_afk | 19:30 | |
*** andrewbogott_afk is now known as andrewbogott | 19:56 | |
*** paul_glass has joined #openstack-dns | 20:03 | |
openstackgerrit | Eric Peterson proposed openstack/designate: Add policy support to designatedashboard https://review.openstack.org/169106 | 20:22 |
*** openstackgerrit has quit IRC | 20:22 | |
*** openstackgerrit has joined #openstack-dns | 20:22 | |
*** ChanServ sets mode: +v openstackgerrit | 20:22 | |
ericpeterson | rebasing horizon changes , no new changes.... ready for another +2 | 20:22 |
openstackgerrit | Eric Peterson proposed openstack/designate: Correct designate-dashboard domain detail screen https://review.openstack.org/173079 | 20:23 |
ZZelle_ | Hi everyone | 20: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 IRC | 20:59 | |
*** logan2 has joined #openstack-dns | 21: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 IRC | 21:17 | |
*** ericpeterson has quit IRC | 21:22 | |
*** openstackgerrit has quit IRC | 21:23 | |
*** openstackgerrit has joined #openstack-dns | 21:23 | |
*** ChanServ sets mode: +v openstackgerrit | 21:23 | |
*** vinod1 has quit IRC | 21:55 | |
*** paul_glass has quit IRC | 21: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 IRC | 22:22 | |
*** andrewbogott is now known as andrewbogott_afk | 22:32 | |
*** EricGonczer_ has joined #openstack-dns | 22:35 | |
*** EricGonczer_ has quit IRC | 22:36 | |
*** EricGonczer_ has joined #openstack-dns | 22:37 | |
*** EricGonczer_ has quit IRC | 22:38 | |
*** andrewbogott_afk is now known as andrewbogott | 22:43 | |
*** ericpeterson has joined #openstack-dns | 22:51 | |
*** ericpeterson has quit IRC | 22:52 | |
*** EricGonczer_ has joined #openstack-dns | 22: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_afk | 23:28 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!