Добрый вечер!
При смене конфигурации для wb-mqtt-db, разрастается файл базы данных, система начинает жутко лагать.
Если ждать какое-то время, зависит от изначального размера БД, то отвисает. Но в течении нескольких часов ничего не работает, очень неудобно.
Консоль
root@IQ248000:~# cat /etc/wb-mqtt-db.conf
{
"database": "/mnt/data/wirenboard/db/data.db",
"debug": false,
"groups": [
{
"channels": [
"0x00158d0001d733e8/battery",
"0x00158d0001d733e8/humidity",
"0x00158d0001d733e8/last_seen",
"0x00158d0001d733e8/linkquality",
"0x00158d0001d733e8/temperature",
"0x00158d0001d733e8/voltage",
"0x00158d0001d76577/battery",
"0x00158d0001d76577/humidity",
"0x00158d0001d76577/last_seen",
"0x00158d0001d76577/linkquality",
"0x00158d0001d76577/temperature",
"0x00158d0001d76577/voltage",
"0x00158d0001d775a9/battery",
"0x00158d0001d775a9/humidity",
"0x00158d0001d775a9/last_seen",
"0x00158d0001d775a9/linkquality",
"0x00158d0001d775a9/temperature",
"0x00158d0001d775a9/voltage",
"0x00158d00058006eb/battery",
"0x00158d00058006eb/humidity",
"0x00158d00058006eb/last_seen",
"0x00158d00058006eb/linkquality",
"0x00158d00058006eb/temperature",
"0x00158d00058006eb/voltage",
"0x00158d00058903e3/battery",
"0x00158d00058903e3/humidity",
"0x00158d00058903e3/last_seen",
"0x00158d00058903e3/linkquality",
"0x00158d00058903e3/temperature",
"0x00158d00058903e3/voltage",
"wb-map12e_12/Ch 1 AP energy L1",
"wb-map12e_12/Ch 1 AP energy L2",
"wb-map12e_12/Ch 1 AP energy L3",
"wb-map12e_12/Ch 1 Ipeak L1",
"wb-map12e_12/Ch 1 Ipeak L2",
"wb-map12e_12/Ch 1 Ipeak L3",
"wb-map12e_12/Ch 1 Irms L1",
"wb-map12e_12/Ch 1 Irms L2",
"wb-map12e_12/Ch 1 Irms L3",
"wb-map12e_12/Ch 1 P L1",
"wb-map12e_12/Ch 1 P L2",
"wb-map12e_12/Ch 1 P L3",
"wb-map12e_12/Ch 1 PF L1",
"wb-map12e_12/Ch 1 PF L2",
"wb-map12e_12/Ch 1 PF L3",
"wb-map12e_12/Ch 1 Phase angle L1",
"wb-map12e_12/Ch 1 Phase angle L2",
"wb-map12e_12/Ch 1 Phase angle L3",
"wb-map12e_12/Ch 1 Q L1",
"wb-map12e_12/Ch 1 Q L2",
"wb-map12e_12/Ch 1 Q L3",
"wb-map12e_12/Ch 1 RP energy L1",
"wb-map12e_12/Ch 1 RP energy L2",
"wb-map12e_12/Ch 1 RP energy L3",
"wb-map12e_12/Ch 1 S L1",
"wb-map12e_12/Ch 1 S L2",
"wb-map12e_12/Ch 1 S L3",
"wb-map12e_12/Ch 2 AP energy L1",
"wb-map12e_12/Ch 2 AP energy L2",
"wb-map12e_12/Ch 2 AP energy L3",
"wb-map12e_12/Ch 2 Ipeak L1",
"wb-map12e_12/Ch 2 Ipeak L2",
"wb-map12e_12/Ch 2 Ipeak L3",
"wb-map12e_12/Ch 2 Irms L1",
"wb-map12e_12/Ch 2 Irms L2",
"wb-map12e_12/Ch 2 Irms L3",
"wb-map12e_12/Ch 2 P L1",
"wb-map12e_12/Ch 2 P L2",
"wb-map12e_12/Ch 2 P L3",
"wb-map12e_12/Ch 2 PF L1",
"wb-map12e_12/Ch 2 PF L2",
"wb-map12e_12/Ch 2 PF L3",
"wb-map12e_12/Ch 2 Phase angle L1",
"wb-map12e_12/Ch 2 Phase angle L2",
"wb-map12e_12/Ch 2 Phase angle L3",
"wb-map12e_12/Ch 2 Q L1",
"wb-map12e_12/Ch 2 Q L2",
"wb-map12e_12/Ch 2 Q L3",
"wb-map12e_12/Ch 2 RP energy L1",
"wb-map12e_12/Ch 2 RP energy L2",
"wb-map12e_12/Ch 2 RP energy L3",
"wb-map12e_12/Ch 2 S L1",
"wb-map12e_12/Ch 2 S L2",
"wb-map12e_12/Ch 2 S L3",
"wb-map12e_12/Ch 3 AP energy L1",
"wb-map12e_12/Ch 3 AP energy L2",
"wb-map12e_12/Ch 3 AP energy L3",
"wb-map12e_12/Ch 3 Ipeak L1",
"wb-map12e_12/Ch 3 Ipeak L2",
"wb-map12e_12/Ch 3 Ipeak L3",
"wb-map12e_12/Ch 3 Irms L1",
"wb-map12e_12/Ch 3 Irms L2",
"wb-map12e_12/Ch 3 Irms L3",
"wb-map12e_12/Ch 3 P L1",
"wb-map12e_12/Ch 3 P L2",
"wb-map12e_12/Ch 3 P L3",
"wb-map12e_12/Ch 3 PF L1",
"wb-map12e_12/Ch 3 PF L2",
"wb-map12e_12/Ch 3 PF L3",
"wb-map12e_12/Ch 3 Phase angle L1",
"wb-map12e_12/Ch 3 Phase angle L2",
"wb-map12e_12/Ch 3 Phase angle L3",
"wb-map12e_12/Ch 3 Q L1",
"wb-map12e_12/Ch 3 Q L2",
"wb-map12e_12/Ch 3 Q L3",
"wb-map12e_12/Ch 3 RP energy L1",
"wb-map12e_12/Ch 3 RP energy L2",
"wb-map12e_12/Ch 3 RP energy L3",
"wb-map12e_12/Ch 3 S L1",
"wb-map12e_12/Ch 3 S L2",
"wb-map12e_12/Ch 3 S L3",
"wb-map12e_12/Ch 4 AP energy L1",
"wb-map12e_12/Ch 4 AP energy L2",
"wb-map12e_12/Ch 4 AP energy L3",
"wb-map12e_12/Ch 4 Ipeak L1",
"wb-map12e_12/Ch 4 Ipeak L2",
"wb-map12e_12/Ch 4 Ipeak L3",
"wb-map12e_12/Ch 4 Irms L1",
"wb-map12e_12/Ch 4 Irms L2",
"wb-map12e_12/Ch 4 Irms L3",
"wb-map12e_12/Ch 4 P L1",
"wb-map12e_12/Ch 4 P L2",
"wb-map12e_12/Ch 4 P L3",
"wb-map12e_12/Ch 4 PF L1",
"wb-map12e_12/Ch 4 PF L2",
"wb-map12e_12/Ch 4 PF L3",
"wb-map12e_12/Ch 4 Phase angle L1",
"wb-map12e_12/Ch 4 Phase angle L2",
"wb-map12e_12/Ch 4 Phase angle L3",
"wb-map12e_12/Ch 4 Q L1",
"wb-map12e_12/Ch 4 Q L2",
"wb-map12e_12/Ch 4 Q L3",
"wb-map12e_12/Ch 4 RP energy L1",
"wb-map12e_12/Ch 4 RP energy L2",
"wb-map12e_12/Ch 4 RP energy L3",
"wb-map12e_12/Ch 4 S L1",
"wb-map12e_12/Ch 4 S L2",
"wb-map12e_12/Ch 4 S L3",
"wb-map12e_12/Frequency",
"wb-map12e_12/Upeak L1",
"wb-map12e_12/Upeak L2",
"wb-map12e_12/Upeak L3",
"wb-map12e_12/Urms L1",
"wb-map12e_12/Urms L2",
"wb-map12e_12/Urms L3",
"wb-map12e_12/Voltage angle L1",
"wb-map12e_12/Voltage angle L2",
"wb-map12e_12/Voltage angle L3",
"wb-map12e_15/Ch 1 AP energy L1",
"wb-map12e_15/Ch 1 AP energy L2",
"wb-map12e_15/Ch 1 AP energy L3",
"wb-map12e_15/Ch 1 Ipeak L1",
"wb-map12e_15/Ch 1 Ipeak L2",
"wb-map12e_15/Ch 1 Ipeak L3",
"wb-map12e_15/Ch 1 Irms L1",
"wb-map12e_15/Ch 1 Irms L2",
"wb-map12e_15/Ch 1 Irms L3",
"wb-map12e_15/Ch 1 P L1",
"wb-map12e_15/Ch 1 P L2",
"wb-map12e_15/Ch 1 P L3",
"wb-map12e_15/Ch 1 PF L1",
"wb-map12e_15/Ch 1 PF L2",
"wb-map12e_15/Ch 1 PF L3",
"wb-map12e_15/Ch 1 Phase angle L1",
"wb-map12e_15/Ch 1 Phase angle L2",
"wb-map12e_15/Ch 1 Phase angle L3",
"wb-map12e_15/Ch 1 Q L1",
"wb-map12e_15/Ch 1 Q L2",
"wb-map12e_15/Ch 1 Q L3",
"wb-map12e_15/Ch 1 RP energy L1",
"wb-map12e_15/Ch 1 RP energy L2",
"wb-map12e_15/Ch 1 RP energy L3",
"wb-map12e_15/Ch 1 S L1",
"wb-map12e_15/Ch 1 S L2",
"wb-map12e_15/Ch 1 S L3",
"wb-map12e_15/Ch 2 AP energy L1",
"wb-map12e_15/Ch 2 AP energy L2",
"wb-map12e_15/Ch 2 AP energy L3",
"wb-map12e_15/Ch 2 Ipeak L1",
"wb-map12e_15/Ch 2 Ipeak L2",
"wb-map12e_15/Ch 2 Ipeak L3",
"wb-map12e_15/Ch 2 Irms L1",
"wb-map12e_15/Ch 2 Irms L2",
"wb-map12e_15/Ch 2 Irms L3",
"wb-map12e_15/Ch 2 P L1",
"wb-map12e_15/Ch 2 P L2",
"wb-map12e_15/Ch 2 P L3",
"wb-map12e_15/Ch 2 PF L1",
"wb-map12e_15/Ch 2 PF L2",
"wb-map12e_15/Ch 2 PF L3",
"wb-map12e_15/Ch 2 Phase angle L1",
"wb-map12e_15/Ch 2 Phase angle L2",
"wb-map12e_15/Ch 2 Phase angle L3",
"wb-map12e_15/Ch 2 Q L1",
"wb-map12e_15/Ch 2 Q L2",
"wb-map12e_15/Ch 2 Q L3",
"wb-map12e_15/Ch 2 RP energy L1",
"wb-map12e_15/Ch 2 RP energy L2",
"wb-map12e_15/Ch 2 RP energy L3",
"wb-map12e_15/Ch 2 S L1",
"wb-map12e_15/Ch 2 S L2",
"wb-map12e_15/Ch 2 S L3",
"wb-map12e_15/Ch 3 AP energy L1",
"wb-map12e_15/Ch 3 AP energy L2",
"wb-map12e_15/Ch 3 AP energy L3",
"wb-map12e_15/Ch 3 Ipeak L1",
"wb-map12e_15/Ch 3 Ipeak L2",
"wb-map12e_15/Ch 3 Ipeak L3",
"wb-map12e_15/Ch 3 Irms L1",
"wb-map12e_15/Ch 3 Irms L2",
"wb-map12e_15/Ch 3 Irms L3",
"wb-map12e_15/Ch 3 P L1",
"wb-map12e_15/Ch 3 P L2",
"wb-map12e_15/Ch 3 P L3",
"wb-map12e_15/Ch 3 PF L1",
"wb-map12e_15/Ch 3 PF L2",
"wb-map12e_15/Ch 3 PF L3",
"wb-map12e_15/Ch 3 Phase angle L1",
"wb-map12e_15/Ch 3 Phase angle L2",
"wb-map12e_15/Ch 3 Phase angle L3",
"wb-map12e_15/Ch 3 Q L1",
"wb-map12e_15/Ch 3 Q L2",
"wb-map12e_15/Ch 3 Q L3",
"wb-map12e_15/Ch 3 RP energy L1",
"wb-map12e_15/Ch 3 RP energy L2",
"wb-map12e_15/Ch 3 RP energy L3",
"wb-map12e_15/Ch 3 S L1",
"wb-map12e_15/Ch 3 S L2",
"wb-map12e_15/Ch 3 S L3",
"wb-map12e_15/Ch 4 AP energy L1",
"wb-map12e_15/Ch 4 AP energy L2",
"wb-map12e_15/Ch 4 AP energy L3",
"wb-map12e_15/Ch 4 Ipeak L1",
"wb-map12e_15/Ch 4 Ipeak L2",
"wb-map12e_15/Ch 4 Ipeak L3",
"wb-map12e_15/Ch 4 Irms L1",
"wb-map12e_15/Ch 4 Irms L2",
"wb-map12e_15/Ch 4 Irms L3",
"wb-map12e_15/Ch 4 P L1",
"wb-map12e_15/Ch 4 P L2",
"wb-map12e_15/Ch 4 P L3",
"wb-map12e_15/Ch 4 PF L1",
"wb-map12e_15/Ch 4 PF L2",
"wb-map12e_15/Ch 4 PF L3",
"wb-map12e_15/Ch 4 Phase angle L1",
"wb-map12e_15/Ch 4 Phase angle L2",
"wb-map12e_15/Ch 4 Phase angle L3",
"wb-map12e_15/Ch 4 Q L1",
"wb-map12e_15/Ch 4 Q L2",
"wb-map12e_15/Ch 4 Q L3",
"wb-map12e_15/Ch 4 RP energy L1",
"wb-map12e_15/Ch 4 RP energy L2",
"wb-map12e_15/Ch 4 RP energy L3",
"wb-map12e_15/Ch 4 S L1",
"wb-map12e_15/Ch 4 S L2",
"wb-map12e_15/Ch 4 S L3",
"wb-map12e_15/Frequency",
"wb-map12e_15/Upeak L1",
"wb-map12e_15/Upeak L2",
"wb-map12e_15/Upeak L3",
"wb-map12e_15/Urms L1",
"wb-map12e_15/Urms L2",
"wb-map12e_15/Urms L3",
"wb-map12e_15/Voltage angle L1",
"wb-map12e_15/Voltage angle L2",
"wb-map12e_15/Voltage angle L3"
],
"min_interval": 120,
"min_unchanged_interval": 120,
"name": "all",
"values": 3759,
"values_total": 0
}
]
}root@IQ248000:~# ls -lh /mnt/data/wirenboard/db/data.db*
-rw-r--r-- 1 root root 263M окт 6 15:37 /mnt/data/wirenboard/db/data.db
-rw-r--r-- 1 root root 131M окт 6 15:36 /mnt/data/wirenboard/db/data.db-journal