{"id":2275,"date":"2019-09-30T12:55:23","date_gmt":"2019-09-30T10:55:23","guid":{"rendered":"http:\/\/les-fougs.com\/wordpress\/?p=2275"},"modified":"2024-01-09T10:34:24","modified_gmt":"2024-01-09T09:34:24","slug":"maintenance-base-domotique","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2019\/09\/30\/maintenance-base-domotique\/","title":{"rendered":"Maintenance base domotique"},"content":{"rendered":"\n

Se connecter root, sur MariaDB 10, puis sur la base domo<\/p>\n\n\n\n

SELECT * FROM graph_tbl WHERE ftimestamp<\/code> < ‘2023-11-01 00:00:00’

create table graph_tbl_2022_1101_2023_1030<\/code> as SELECT * FROM graph_tbl WHERE ftimestamp<\/code> < ‘2023-11-01 00:00:00’<\/p>\n\n\n\n

delete FROM graph_tbl WHERE ftimestamp<\/code> < ‘2023-11-01 00:00:00’<\/p>\n\n\n\n

CREATE UNIQUE INDEX idx_mesure ON graph_tbl2022_1101_2023_1030<\/code><\/code> (ffeed(15),ftimestamp)<\/p>\n\n\n\n

drop INDEX idx_mesure ON graph_tbl<\/code> <\/p>\n\n\n\n

CREATE UNIQUE INDEX idx_mesure ON graph_tbl<\/code> (ffeed(15),ftimestamp)<\/p>\n\n\n\n

———————————————————-<\/p>\n\n\n\n

create table graph_conso_2022_1001<\/code> as SELECT * FROM graph_conso WHERE ftimestamp<\/code> < ‘2022-10-01 00:00:00’<\/p>\n\n\n\n

delete FROM graph_conso WHERE ftimestamp<\/code> < ‘2022-10-01 00:00:00’<\/p>\n\n\n\n

CREATE UNIQUE INDEX idx_mesure ON graph_conso_2022_1001<\/code> (ffeed(15),ftimestamp)<\/p>\n\n\n\n

drop INDEX idx_mesure ON graph_conso<\/code><\/p>\n\n\n\n

CREATE UNIQUE INDEX idx_mesure ON graph_conso<\/code> (ffeed(15),ftimestamp)<\/p>\n","protected":false},"excerpt":{"rendered":"

Se connecter root, sur MariaDB 10, puis sur la base domo SELECT * FROM graph_tbl WHERE ftimestamp < ‘2023-11-01 00:00:00’ create table graph_tbl_2022_1101_2023_1030 as SELECT * FROM graph_tbl WHERE ftimestamp < ‘2023-11-01 00:00:00’ delete FROM graph_tbl WHERE ftimestamp < ‘2023-11-01 00:00:00’ CREATE UNIQUE INDEX idx_mesure ON graph_tbl2022_1101_2023_1030 (ffeed(15),ftimestamp) drop INDEX idx_mesure ON graph_tbl CREATE UNIQUE … Continuer la lecture de « Maintenance base domotique »<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,64,35],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/2275"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2275"}],"version-history":[{"count":9,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/2275\/revisions"}],"predecessor-version":[{"id":2517,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/2275\/revisions\/2517"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2275"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}