Maintenance base domotique

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 INDEX idx_mesure ON graph_tbl (ffeed(15),ftimestamp)

———————————————————-

create table graph_conso_2022_1001 as SELECT * FROM graph_conso WHERE ftimestamp < ‘2022-10-01 00:00:00’

delete FROM graph_conso WHERE ftimestamp < ‘2022-10-01 00:00:00’

CREATE UNIQUE INDEX idx_mesure ON graph_conso_2022_1001 (ffeed(15),ftimestamp)

drop INDEX idx_mesure ON graph_conso

CREATE UNIQUE INDEX idx_mesure ON graph_conso (ffeed(15),ftimestamp)