{"id":1704,"date":"2020-10-28T10:23:41","date_gmt":"2020-10-28T09:23:41","guid":{"rendered":"https:\/\/blog.mhasin.eu\/?p=1704"},"modified":"2020-10-31T21:20:04","modified_gmt":"2020-10-31T20:20:04","slug":"vala-pdns-mysql-table-optimize","status":"publish","type":"post","link":"https:\/\/blog.mhasin.eu\/?p=1704","title":{"rendered":"VALA PDNS mysql table optimize"},"content":{"rendered":"\n<p>Povodny select na tabulku record:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`147.232.191.6` SQL SECURITY DEFINER VIEW `records` AS select `lmsfin`.`dns_pdns`.`id` + 50 AS `id`,cast(`lmsfin`.`dns_pdns`.`domain_id` as signed) AS `domain_id`,cast(`lmsfin`.`dns_pdns`.`name` as char(255) charset utf8mb4) AS `name`,cast(`lmsfin`.`dns_pdns`.`type` as char(10) charset utf8mb4) AS `type`,cast(`lmsfin`.`dns_pdns`.`content` as char(64000) charset utf8mb4) AS `content`,`lmsfin`.`dns_pdns`.`ttl` AS `ttl`,`lmsfin`.`dns_pdns`.`prio` AS `prio`,`lmsfin`.`dns_pdns`.`change_date` AS `change_date`,`lmsfin`.`dns_pdns`.`disabled` AS `disabled`,cast(`lmsfin`.`dns_pdns`.`ordername` as char(255) charset utf8mb4) AS `ordername`,`lmsfin`.`dns_pdns`.`auth` AS `auth` from `lmsfin`.`dns_pdns` union select `lmsfin`.`nodes`.`id` + 10000 AS `id`,cast((select `lmsfin`.`servis_zona`.`dnszone` AS `dnszone` from `lmsfin`.`servis_zona` where `lmsfin`.`servis_zona`.`seq` = (select `lmsfin`.`customers`.`seq_servis_zona` AS `seq_servis_zona` from `lmsfin`.`customers` where `lmsfin`.`customers`.`id` = `lmsfin`.`nodes`.`ownerid`)) as signed) AS `domain_id`,concat_ws('.',lcase(`lmsfin`.`nodes`.`name`),(select `lmsfin`.`domains`.`name` from `lmsfin`.`domains` where `lmsfin`.`domains`.`id` = (select `lmsfin`.`servis_zona`.`dnszone` AS `dnszone` from `lmsfin`.`servis_zona` where `lmsfin`.`servis_zona`.`seq` = (select `lmsfin`.`customers`.`seq_servis_zona` AS `seq_servis_zona` from `lmsfin`.`customers` where `lmsfin`.`customers`.`id` = `lmsfin`.`nodes`.`ownerid`)))) AS `name`,'A' AS `type`,cast(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`) as char(64000) charset utf8mb4) AS `content`,86400 AS `ttl`,NULL AS `prio`,0 AS `change_date`,0 AS `disabled`,cast(NULL as char(255) charset utf8mb4) AS `ordername`,1 AS `auth` from `lmsfin`.`nodes` where `lmsfin`.`nodes`.`access` = 1 and (select `lmsfin`.`customers`.`status` from `lmsfin`.`customers` where `lmsfin`.`customers`.`id` = `lmsfin`.`nodes`.`ownerid`) &lt;> 1 union select cast(`lmsfin`.`nodes`.`id` as signed) + 1000000 AS `id`,cast(`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',3) as signed) AS `domain_id`,cast(concat_ws('.',`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',4),`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',3),`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',2),`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',1),'in-addr.arpa') as char(255) charset utf8mb4) AS `name`,'PTR' AS `type`,cast(concat(lcase(`lmsfin`.`nodes`.`name`),concat(_utf8'.',(select `lmsfin`.`soa`.`origin` AS `origin` from `lmsfin`.`soa` where `lmsfin`.`soa`.`id` = (select `lmsfin`.`servis_zona`.`dnszone` AS `dnszone` from `lmsfin`.`servis_zona` where `lmsfin`.`servis_zona`.`seq` = (select `lmsfin`.`customers`.`seq_servis_zona` AS `seq_servis_zona` from `lmsfin`.`customers` where `lmsfin`.`customers`.`id` = `lmsfin`.`nodes`.`ownerid`))))) as char(64000) charset utf8mb4) AS `content`,86400 AS `ttl`,NULL AS `prio`,0 AS `change_date`,0 AS `disabled`,cast(NULL as char(255) charset utf8mb4) AS `ordername`,1 AS `auth` from `lmsfin`.`nodes` where `lmsfin`.`nodes`.`access` = 1 and `lmsfin`.`nodes`.`linktype` = 0 and (select `lmsfin`.`customers`.`status` from `lmsfin`.`customers` where `lmsfin`.`customers`.`id` = `lmsfin`.`nodes`.`ownerid`) &lt;> 1 union select `lmsfin`.`soa`.`id` AS `id`,`lmsfin`.`soa`.`id` AS `domain_id`,`lmsfin`.`soa`.`origin` AS `name`,'SOA' AS `type`,concat_ws(' ',`lmsfin`.`soa`.`ns`,`lmsfin`.`soa`.`mbox`,`lmsfin`.`soa`.`serial`,`lmsfin`.`soa`.`refresh`,`lmsfin`.`soa`.`retry`,`lmsfin`.`soa`.`expire`,`lmsfin`.`soa`.`minimum`) AS `content`,`lmsfin`.`soa`.`ttl` AS `ttl`,NULL AS `prio`,0 AS `change_date`,0 AS `disabled`,'' AS `ordername`,1 AS `auth` from `lmsfin`.`soa`<\/code><\/pre>\n\n\n\n<p>Nova verzia:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select `lmsfin`.`dns_pdns`.`id` + 50 AS `id`,\n\n\n\ncast(`lmsfin`.`dns_pdns`.`domain_id` as signed) AS `domain_id`,\ncast(`lmsfin`.`dns_pdns`.`name` as char(255) charset utf8mb4) AS `name`,\ncast(`lmsfin`.`dns_pdns`.`type` as char(10) charset utf8mb4) AS `type`,\ncast(`lmsfin`.`dns_pdns`.`content` as char(64000) charset utf8mb4) AS `content`,\n`lmsfin`.`dns_pdns`.`ttl` AS `ttl`,\n`lmsfin`.`dns_pdns`.`prio` AS `prio`,\n`lmsfin`.`dns_pdns`.`change_date` AS `change_date`,\n`lmsfin`.`dns_pdns`.`disabled` AS `disabled`,\ncast(`lmsfin`.`dns_pdns`.`ordername` as char(255) charset utf8mb4) AS `ordername`,\n`lmsfin`.`dns_pdns`.`auth` AS `auth` from `lmsfin`.`dns_pdns` union \n\n\n\nselect `lmsfin`.`nodes`.`id` + 10000 AS `id`,\n `lmsfin`.`servis_zona`.`dnszone` AS    `domain_id`,\n concat_ws('.',lcase(`lmsfin`.`nodes`.`name`),`lmsfin`.domains.name) as `name`,\n  'A' AS `type`,\n   cast(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`) as char(64000) charset utf8mb4) AS `content`\n   ,86400 AS `ttl`\n   ,NULL AS `prio`\n   ,`lmsfin`.nodes.moddate AS `change_date`,\n   0 AS `disabled`,\n   cast(NULL as char(255) charset utf8mb4) AS `ordername`,\n   1 AS `auth` \n    from `lmsfin`.nodes\n\n\ninner join `lmsfin`.customers on `lmsfin`.customers.id = `lmsfin`.nodes.ownerid \ninner join `lmsfin`.servis_zona on `lmsfin`.customers.seq_servis_zona = `lmsfin`.servis_zona.seq\ninner join `lmsfin`.domains on `lmsfin`.servis_zona.dnszone = `lmsfin`.domains.id\ninner join `lmsfin`.passwd on `lmsfin`.passwd.ownerid = `lmsfin`.nodes.ownerid and `lmsfin`.passwd.`expdate` > unix_timestamp()\nwhere `lmsfin`.`nodes`.`access` = 1\n\n\nunion select `lmsfin`.`nodes`.`id` + 1000000 AS `id`,\n\ncast(`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',3) as signed) AS `domain_id`,\n\n\n\ncast(concat_ws('.',`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',4),`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',3),`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',2),`SPLIT_STRING`(inet_ntoa(`lmsfin`.`nodes`.`ipaddr`),'.',1),'in-addr.arpa') as char(255) charset utf8mb4) AS `name`,\n\n'PTR' AS `type`,\n\n\ncast(concat(lcase(`lmsfin`.`nodes`.`name`),concat(_utf8'.',(select `lmsfin`.`soa`.`origin` AS `origin` from `lmsfin`.`soa` where `lmsfin`.`soa`.`id` = `lmsfin`.servis_zona.dnszone ))) as char(64000) charset utf8mb4) AS `content`,\n\n\n86400 AS `ttl`,\n\nNULL AS `prio`,\n`lmsfin`.nodes.moddate AS `change_date`,\n0 AS `disabled`,\n\ncast(NULL as char(255) charset utf8mb4) AS `ordername`,1 AS `auth` from `lmsfin`.`nodes` \n\ninner join `lmsfin`.customers on `lmsfin`.customers.id = `lmsfin`.nodes.ownerid \ninner join `lmsfin`.servis_zona on `lmsfin`.customers.seq_servis_zona = `lmsfin`.servis_zona.seq\ninner join `lmsfin`.domains on `lmsfin`.servis_zona.dnszone = `lmsfin`.domains.id\ninner join `lmsfin`.passwd on `lmsfin`.passwd.ownerid = `lmsfin`.nodes.ownerid and `lmsfin`.passwd.`expdate` > unix_timestamp()\n\n\nwhere `lmsfin`.`nodes`.`access` = 1\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nunion select `lmsfin`.`soa`.`id` AS `id`,`lmsfin`.`soa`.`id` AS `domain_id`,`lmsfin`.`soa`.`origin` AS `name`,'SOA' AS `type`,concat_ws(' ',`lmsfin`.`soa`.`ns`,`lmsfin`.`soa`.`mbox`,`lmsfin`.`soa`.`serial`,`lmsfin`.`soa`.`refresh`,`lmsfin`.`soa`.`retry`,`lmsfin`.`soa`.`expire`,`lmsfin`.`soa`.`minimum`) AS `content`,`lmsfin`.`soa`.`ttl` AS `ttl`,NULL AS `prio`,0 AS `change_date`,0 AS `disabled`,'' AS `ordername`,1 AS `auth` from `lmsfin`.`soa`<\/code><\/pre>\n<div class=\"pdf24Plugin-cp\"> \t<form name=\"pdf24Form0\" method=\"post\" action=\"https:\/\/doc2pdf.pdf24.org\/wordpress.php\" target=\"pdf24PopWin\" onsubmit=\"var pdf24Win = window.open('about:blank', 'pdf24PopWin', 'resizable=yes,scrollbars=yes,width=600,height=250,left='+(screen.width\/2-300)+',top='+(screen.height\/3-125)+''); pdf24Win.focus(); if(typeof pdf24OnCreatePDF === 'function'){void(pdf24OnCreatePDF(this,pdf24Win));}\"> \t\t<input type=\"hidden\" name=\"blogCharset\" value=\"Cw1x07UAAA==\" \/><input type=\"hidden\" name=\"blogPosts\" value=\"MwQA\" \/><input type=\"hidden\" name=\"blogUrl\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLQUA\" \/><input type=\"hidden\" name=\"blogName\" value=\"c\/LxdwcA\" \/><input type=\"hidden\" name=\"blogValueEncoding\" value=\"gzdeflate base64\" \/><input type=\"hidden\" name=\"postId_0\" value=\"MzQ3MAEA\" \/><input type=\"hidden\" name=\"postTitle_0\" value=\"C3P0cVQIcPELVsitLC7MUShJTMpJVcgvKMnMzaxKBQA=\" \/><input type=\"hidden\" name=\"postLink_0\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLdW3L7A1NDcwAQA=\" \/><input type=\"hidden\" name=\"postAuthor_0\" value=\"y00syfcwNAIA\" \/><input type=\"hidden\" name=\"postDateTime_0\" value=\"MzIwMtA1NNA1slAwNLACIhNDAA==\" \/><input type=\"hidden\" name=\"postContent_0\" value=\"7Vhbc+I2FH7Xr9DsQ8FTwkI22W63wDSzS7fMUDYFsjt9soWtJGpsybVESPbXV7IMvglis2Qm0+KHIB+fiy7nfEdfQC8cXLJ75tFHyLGPXQEpggItlv7dEkbYZZH3vvc6HAD59MIIQ9dHnPdfrcKThc\/cuxOXefjVoKd+Bh+mw4v5EF6MP32ejua\/\/9G\/mnwc\/jaaDD9C\/TvtOxFjwvnV6Z791D59c9ru\/txtv3Xg7M8xnA0\/XEmzv9a68Mto+BU6ehLcgRez9RQdP+DXhDptx6PcDuUfOSSeA3+E5x2lp15aLuKiaVT1WIAItZUF4pCTG4o9K7ZLv+wwpyjAsaV7i6Lm6fm5FY84FnAprt8FizPtLNbb4Uc8hhk\/3c4WN7HaDjcuowJTkXp6e9bpbHO2Vm6ZZyR8R8eUA7NKGBGmdeKRWUmGpjfY9pDAWjcrMJt4hKOFjz2tv3nbsW6ZFTiqehapsjk8WopbHVqPriMWmPIMLilhtJyIVOZ\/moVdeQCFRGyWTDiO7gm3vzGKdAQ5SrZr81KYRtYErm6xrMdt\/jj+x4F9WA7rLrlgAY64VrJzPlXwkrAwidRBaQpZ32on+oYdYiuKI\/nRsnYVH6MuEvaKNxvtRsuXO4ibZVfxeVqt8hq1p7RWi6eZfC7NP7XTsz8eWunQrCy2NS4aRYgiFAubCoYM50VC5HmRY9VDqndKK0WlydV4nMGfThlfOiYIic1q4UR3OxzoBZV2cr1O5LqYc7WTXYio99R5CiSW\/NlODP7gi18GciY55CrAaha+MlWZIFkRy5zZ5Xg0t2fz6Wjyyal05C1Vx2+sp\/ptvu73jXNmtfaf4t6mp\/ubduUPoSdK0kZRiBpW5etF43I+LRWh3sbmE7iZaNnKq5qFAe0YihstuZGvSX3ocRHjmAnbYusjkm5F0v8dEJY1fELv9D24DzsvFSxNKb0GxG3fMsi2q56SIp59znfSFAZho2QvLyglWbBgD2WpzGOC\/LI8wtcR5remDyJ6LIvxQ0gibIhKKAmWgbOVW2i1PK2on7eNRo2UVCF7r2M+KolrhBPqOpiwewTvcfSNoAyjHRiHT\/DcWjRUefxOKgoOxUXBgcgoODQbBRXoKKjER8EehBTUYqTg8JQUHIKTqkSrxUtBpW4sn1wuwlrcbPMhoVZtJY\/73jolIcyzCCmAz8MklOdCE41FeUCKRZuIccB2wDyVKYbMkcpFtNosoH6nVaZZaFPvhWOPJyRPmlDZsuDfjND026bVQWaStomX7X56aUnrg0aHmazY4rJwW8r6z4iVmjFAkhU551m7JBGzbteJRDyjx1DC9srLOdSizUq3bkHuhpIYqdanUWOgyuzBFiTA8hIShE0LVLj2yJOq\/h+jbG2C52Nam450ZFt12RYARb6V38uXRLl2FlRt8iHXWeAfABRucqAyapYgEzwbNTki5UtASlARKwvPkYX9d1jYvw==\" \/> \t\t<a href=\"https:\/\/www.pdf24.org\" target=\"_blank\" title=\"www.pdf24.org\" rel=\"nofollow\"><img src=\"https:\/\/blog.mhasin.eu\/wp-content\/plugins\/pdf24-post-to-pdf\/img\/pdf_32x32.png\" alt=\"\" border=\"0\" height=\"32\" \/><\/a> \t\t<span class=\"pdf24Plugin-cp-space\">&nbsp;&nbsp;<\/span> \t\t<span class=\"pdf24Plugin-cp-text\">Send article as PDF<\/span> \t\t<span class=\"pdf24Plugin-cp-space\">&nbsp;&nbsp;<\/span> \t\t<input class=\"pdf24Plugin-cp-input\" style=\"margin: 0px;\" type=\"text\" name=\"sendEmailTo\" placeholder=\"Enter email address\" \/> \t\t<input class=\"pdf24Plugin-cp-submit\" style=\"margin: 0px;\" type=\"submit\" value=\"Send\" \/> \t<\/form> <\/div>","protected":false},"excerpt":{"rendered":"Povodny select na tabulku record: Nova verzia: &nbsp;&nbsp; Send article as PDF &nbsp;&nbsp;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"arc_restricted_post":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1704","post","type-post","status-publish","format-standard","hentry","category-programovanie"],"_links":{"self":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/1704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1704"}],"version-history":[{"count":2,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/1704\/revisions"}],"predecessor-version":[{"id":1720,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/1704\/revisions\/1720"}],"wp:attachment":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}