Uptime: 14.8 days
Queries/second, 1, 5, 10 minute averages: 0, 0, 0. Max queries/second: 2
Cache hitrate, 1, 5, 10 minute averages: 0.0%, 0.0%, 0.0%
Backend query cache hitrate, 1, 5, 10 minute averages: 62.5%, 58.9%, 55.0%
Backend query load, 1, 5, 10 minute averages: 0, 0, 0. Max queries/second: 0
Total queries: 24881. Question/answer latency: 0.703ms
| no primary or producer domains need notifications | 167 | 16.7% |
| Query 139904466082240: select d.id, d.name, d.type, d.notified_serial,d.options, d.catalog,r.content from records r join domains d on r.domain_id=d.id and r.name=d.name where r.type='SOA' and r.disabled=0 and d.type in ('MASTER', 'PRODUCER') order by d.id | 166 | 16.6% |
| gmysql Connection successful. Connected to database 'powerdns' on 'mysql'. | 34 | 3.4% |
| Query 139903929206336: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=? | 9 | 0.9% |
| Query 139903862097552: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=? | 9 | 0.9% |
| Query 139903929215632: select kind,content from domains, domainmetadata where domainmetadata.domain_id=domains.id and name=? | 6 | 0.6% |
| Query 139903862106720: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=? | 6 | 0.6% |
| Query 94251706994960: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 6 | 0.6% |
| Query 139903996315296: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name=? and domain_id=? | 5 | 0.5% |
| Query 139903929215360: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=? | 5 | 0.5% |
| Query 139903862106992: select kind,content from domains, domainmetadata where domainmetadata.domain_id=domains.id and name=? | 5 | 0.5% |
| Query 94251742366800: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 5 | 0.5% |
| Query 94251753359040: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 4 | 0.4% |
| Query 139903996324464: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=? | 4 | 0.4% |
| Query 94251707068512: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 4 | 0.4% |
| Query 139903996324736: select kind,content from domains, domainmetadata where domainmetadata.domain_id=domains.id and name=? | 3 | 0.3% |
| Query 94251734561504: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 2 | 0.2% |
| Query 139904466082240: 200237 us total to last row | 2 | 0.2% |
| Query 94251706995024: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 2 | 0.2% |
| Query 139904466082240: 200477 us to execute | 2 | 0.2% |
| Query 94251753358912: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 2 | 0.2% |
| Query 139904466082240: 220310 us total to last row | 2 | 0.2% |
| Query 94251743122592: select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.last_check, domains.account, domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0 OR ? | 2 | 0.2% |
| Query 139904466082240: 201562 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206363 us to execute | 1 | 0.1% |
| Query 139904466082240: 206308 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206280 us to execute | 1 | 0.1% |
| Query 139904466082240: 206274 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206036 us to execute | 1 | 0.1% |
| Query 139904466082240: 206240 us to execute | 1 | 0.1% |
| Query 139904466082240: 206154 us to execute | 1 | 0.1% |
| Query 139904466082240: 206380 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206151 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206403 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206423 us to execute | 1 | 0.1% |
| Query 139904466082240: 206141 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206123 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206503 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205783 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205176 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205294 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205307 us to execute | 1 | 0.1% |
| Query 139904466082240: 205439 us to execute | 1 | 0.1% |
| Query 139904466082240: 205461 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205565 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205594 us to execute | 1 | 0.1% |
| Query 139904466082240: 205605 us to execute | 1 | 0.1% |
| Query 139904466082240: 206122 us to execute | 1 | 0.1% |
| Query 139904466082240: 205843 us to execute | 1 | 0.1% |
| Query 139904466082240: 205854 us total to last row | 1 | 0.1% |
| Query 139904466082240: 205967 us to execute | 1 | 0.1% |
| Query 139904466082240: 205971 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206004 us to execute | 1 | 0.1% |
| Query 139904466082240: 206605 us total to last row | 1 | 0.1% |
| Query 139904466082240: 201600 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207789 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207648 us total to last row | 1 | 0.1% |
| Query 139904466082240: 201510 us to execute | 1 | 0.1% |
| Query 139904466082240: 207659 us to execute | 1 | 0.1% |
| Query 139904466082240: 207711 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207721 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207740 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207776 us to execute | 1 | 0.1% |
| Query 139904466082240: 207783 us to execute | 1 | 0.1% |
| Query 139904466082240: 207604 us to execute | 1 | 0.1% |
| Query 139904466082240: 207909 us total to last row | 1 | 0.1% |
| Query 139904466082240: 201129 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207951 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207991 us to execute | 1 | 0.1% |
| Query 139904466082240: 208081 us to execute | 1 | 0.1% |
| Query 139904466082240: 208139 us total to last row | 1 | 0.1% |
| Query 139904466082240: 201451 us to execute | 1 | 0.1% |
| Query 139904466082240: 206822 us to execute | 1 | 0.1% |
| Query 139904466082240: 206582 us to execute | 1 | 0.1% |
| Query 139904466082240: 205134 us to execute | 1 | 0.1% |
| Query 139904466082240: 206645 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206658 us to execute | 1 | 0.1% |
| Query 139904466082240: 206695 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206782 us to execute | 1 | 0.1% |
| Query 139904466082240: 206794 us total to last row | 1 | 0.1% |
| Query 139904466082240: 201527 us to execute | 1 | 0.1% |
| Query 139904466082240: 206506 us to execute | 1 | 0.1% |
| Query 139904466082240: 206880 us to execute | 1 | 0.1% |
| Query 139904466082240: 206939 us total to last row | 1 | 0.1% |
| Query 139904466082240: 206967 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207031 us total to last row | 1 | 0.1% |
| Query 139904466082240: 207500 us to execute | 1 | 0.1% |
| Query 139904466082240: 207548 us to execute | 1 | 0.1% |
| Query 139904466082240: 207567 us to execute | 1 | 0.1% |
| Query 139904466082240: 203134 us to execute | 1 | 0.1% |
| Query 139904466082240: 202898 us total to last row | 1 | 0.1% |
| Query 139904466082240: 202947 us total to last row | 1 | 0.1% |
| Query 139904466082240: 202969 us total to last row | 1 | 0.1% |
| Query 139904466082240: 203048 us to execute | 1 | 0.1% |
| Query 139904466082240: 203107 us to execute | 1 | 0.1% |
| Query 139904466082240: 203124 us to execute | 1 | 0.1% |
| Query 139904466082240: 201909 us to execute | 1 | 0.1% |
| Query 139904466082240: 201897 us to execute | 1 | 0.1% |
| Query 139904466082240: 202843 us to execute | 1 | 0.1% |
| Query 139904466082240: 203206 us to execute | 1 | 0.1% |
| Rest: | 471 | 47.1% |
| Total: | 1000 | 100% |