Merci d’avoir déplacé le post ( Je pensait que le problème venait de JMQTT).
En Avril 2022 j’avais déja ce problème de mémoire :
https://community.jeedom.com/t/memoire-suffisante-6/83615
On m’avait conseillé d’historisé « Mémoire libre (pourcentage) » avec le pluging Monitoring , chose que je fait.
Si je ne redémarre pas jeedom de temps en temps la mémoire n’arrête pas de baisser.
Ok, merci je vais faire ça. et vous tiens au courant ( si je peut vous solliciter )
Bonne journée
C’est correct, mais il me semble qu’il y a quand même une fuite mémoire quelque que part, je ne suis pas contre regarder d’où ça vient pour le bien collectif
jMQTT a eu un gros lifting cet été pour réduire considérablement la charge et l’empreinte mémoire, donc je me doutais bien que ça ne viennent (probablement) pas de là.
Bad
On peut voir sur l’historique que le 14 aout il n’y avait que 64 % de mémoire libre . c’est a ce moment que j’ai redémarrer Jeedom.
Bonjour Bad.
Je me permet de vous resollicité 1 mois et 10 jours après mon soucis de mémoire.
j’ai toujours la mémoire qui baisse inlassablement.
Pour rappel:
Version jeedom 4.2.19 Atlas
le 14 aout j’étais a 84% ( moment ou j’ai redémarrer jeedom )
et aujourd’hui le 1er octobre je suis a 65%.
et j’ai l’impression que jeedom commence a ramer.
ci joint les resultats de la requete « memory usage » et « taille » du 21 aout et aujourd’hui comme vous m’aviez conseillé de faire.
SIZE PID USER COMMAND
883696 1785 mysql /usr/sbin/mysqld
89296 2670 www-data /usr/bin/python3 /var/www/html/plugins/zigbee/resources/zigbeed/zigbeed.py --device /dev/ttyUSB0 --loglevel error --socketport 8089 --callback http://127.0.0.1:80/plugins/zigbee/core/php/jeeZigbee.php --apikey pkbNT36KgB2quKBBa21NpfKyC1KsyWnK --cycle 0.3 --pid /tmp/jeedom/zigbee/deamon_1.pid --data_folder /var/www/html/plugins/zigbee/data/1 --device_folder /var/www/html/plugins/zigbee/data/device --controller ezsp --sub_controller elelabs --channel 15
55516 2305 www-data nodejs /var/www/html/plugins/espeasy/resources/espeasy.js 192.168.1.60 http://127.0.0.1:80/plugins/espeasy/core/api/jeeEspeasy.php?apikey=SaikOd0Qrbsi65QTwInXcCdSdsEqOvaFum99aO6DTjftxplBB2fr79iRVOYlDdIq 400
50252 1660 root /usr/bin/python3 /usr/bin/fail2ban-server -xf start
43988 2239 root /usr/bin/python3 /var/www/html/plugins/broadlink/resources/broadlinkd/broadlinkd.py --loglevel error --socketport 55013 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/broadlink/core/php/jeeBroadlink.php --apikey YLNMsKXjCyrLvftY0k6NmVLYGCxgeW4E --cycle 0.3 --pid /tmp/jeedom/broadlink/deamon.pid
38392 2394 www-data /var/www/html/plugins/jMQTT/resources/jmqttd/venv/bin/python3 /var/www/html/plugins/jMQTT/resources/jmqttd/jmqttd.py --loglevel error --callback http://localhost:80/plugins/jMQTT/core/php/callback.php --apikey ct83WUM9hOF0qlBLTi6QPVaI3I8MiBdg --pid /tmp/jeedom/jMQTT/jmqttd.py.pid
36108 2358 www-data php /var/www/html/plugins/JeedomConnect/core/class/../../core/php/server.php
35660 1474 root /usr/sbin/NetworkManager --no-daemon
29448 2346 www-data php /var/www/html/core/class/../php/jeeCron.php cron_id=34
25840 1790 root /usr/lib/policykit-1/polkitd --no-debug
25368 1659 root /sbin/apcupsd
25176 1449 root /usr/sbin/rngd -r /dev/urandom
23252 691 root /lib/systemd/systemd-journald
18748 2940 www-data /usr/sbin/apache2 -k start
18728 1 root /sbin/init
18364 1424 root /usr/sbin/rsyslogd -n -iNONE
16876 3283 www-data /usr/sbin/apache2 -k start
16828 1630 root /usr/bin/python3 /usr/share/unattended-upgrades/unattended-upgrade-shutdown --wait-for-signal
16576 6523 www-data /usr/sbin/apache2 -k start
10208 6533 www-data /usr/sbin/apache2 -k start
9096 5346 www-data php /var/www/html/core/class/../php/jeeCron.php cron_id=1343
8340 1477 root /usr/bin/python3 /usr/bin/networkd-dispatcher --run-startup-triggers
8316 3985 www-data /usr/sbin/apache2 -k start
8268 30966 www-data /usr/sbin/apache2 -k start
8036 6281 www-data /usr/sbin/apache2 -k start
8036 19174 www-data /usr/sbin/apache2 -k start
7972 3766 www-data /usr/sbin/apache2 -k start
7972 6227 www-data /usr/sbin/apache2 -k start
7956 3774 www-data /usr/sbin/apache2 -k start
7444 1800 root /usr/sbin/apache2 -k start
6008 694 root /usr/sbin/haveged --Foreground --verbose=1 -w 1024
1308 1664 ntp /usr/sbin/ntpd -p /var/run/ntpd.pid -g -u 110:119
1284 1890 root /sbin/dhclient -d -q -sf /usr/lib/NetworkManager/nm-dhcp-helper -pf /run/dhclient-eth0.pid -lf /var/lib/NetworkManager/dhclient-28ba06af-b987-33b2-a264-87ee4b7efb57-eth0.lease -cf /var/lib/NetworkManager/dhclient-eth0.conf eth0
1192 2493 root openvpn --config /tmp/jeedom/openvpn/openvpn_1.ovpn
1180 6392 www-data ps -eo size,pid,user,command --sort -size
1172 425 root /lib/systemd/systemd-udevd
984 1462 message+ /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only
960 1655 root /usr/sbin/sshd -D
912 1608 mosquit+ /usr/sbin/mosquitto -c /etc/mosquitto/mosquitto.conf
872 1469 root /sbin/wpa_supplicant -u -s -O /run/wpa_supplicant
744 2238 root sudo /usr/bin/python3 /var/www/html/plugins/broadlink/resources/broadlinkd/broadlinkd.py --loglevel error --socketport 55013 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/broadlink/core/php/jeeBroadlink.php --apikey YLNMsKXjCyrLvftY0k6NmVLYGCxgeW4E --cycle 0.3 --pid /tmp/jeedom/broadlink/deamon.pid
744 2486 root sudo openvpn --config /tmp/jeedom/openvpn/openvpn_1.ovpn
696 1475 avahi avahi-daemon: running [JeedomAtlas.local]
688 1482 root /lib/systemd/systemd-logind
592 1485 root /usr/lib/bluetooth/bluetoothd
484 1422 root /usr/sbin/alsactl -E HOME=/run/alsa -s -n 19 -c rdaemon
452 1486 avahi avahi-daemon: chroot helper
444 1448 root /usr/sbin/cron -f
444 1492 daemon /usr/sbin/atd -f
344 1670 root /sbin/agetty -o -p -- \u --noclear tty1 linux
324 1600 vnstat /usr/sbin/vnstatd -n
316 6391 www-data sh -c ps -eo size,pid,user,command --sort -size 2>&1
0 2 root [kthreadd]
0 3 root [rcu_gp]
0 4 root [rcu_par_gp]
0 8 root [mm_percpu_wq]
0 9 root [rcu_tasks_kthre]
0 10 root [rcu_tasks_rude_]
0 11 root [rcu_tasks_trace]
0 12 root [ksoftirqd/0]
0 13 root [rcu_preempt]
0 14 root [migration/0]
0 15 root [cpuhp/0]
0 16 root [cpuhp/1]
0 17 root [migration/1]
0 18 root [ksoftirqd/1]
0 21 root [cpuhp/2]
0 22 root [migration/2]
0 23 root [ksoftirqd/2]
0 26 root [cpuhp/3]
0 27 root [migration/3]
0 28 root [ksoftirqd/3]
0 31 root [cpuhp/4]
0 32 root [migration/4]
0 33 root [ksoftirqd/4]
0 36 root [cpuhp/5]
0 37 root [migration/5]
0 38 root [ksoftirqd/5]
0 41 root [kdevtmpfs]
0 42 root [netns]
0 48 root [kauditd]
0 49 root [oom_reaper]
0 50 root [writeback]
0 51 root [kcompactd0]
0 52 root [ksmd]
0 53 root [khugepaged]
0 85 root [cryptd]
0 146 root [kintegrityd]
0 147 root [kblockd]
0 148 root [blkcg_punt_bio]
0 160 root [ata_sff]
0 163 root [edac-poller]
0 164 root [devfreq_wq]
0 165 root [watchdogd]
0 216 root [kswapd0]
0 217 root [ecryptfs-kthrea]
0 220 root [kthrotld]
0 221 root [irq/74-rockchip]
0 222 root [irq/75-rockchip]
0 224 root [nvme-wq]
0 225 root [nvme-reset-wq]
0 226 root [nvme-delete-wq]
0 227 root [vfio-irqfd-clea]
0 228 root [irq/78-rk808]
0 229 root [irq/48-rockchip]
0 230 root [bch_btree_io]
0 231 root [bcache]
0 232 root [bch_journal]
0 235 root [kworker/u13:0-hci0]
0 236 root [sdhci]
0 237 root [irq/38-mmc2]
0 238 root [irq/88-fe320000]
0 242 root [ipv6_addrconf]
0 249 root [mmc_complete]
0 254 root [kstrp]
0 257 root [zswap1]
0 258 root [zswap1]
0 259 root [zswap-shrink]
0 316 root [stmmac_wq]
0 349 root [jbd2/mmcblk2p1-]
0 350 root [ext4-rsv-conver]
0 529 root [kworker/1:2-cgroup_destroy]
0 549 root [cfg80211]
0 552 root [kworker/0:2-events]
0 562 root [irq/54-ff660000]
0 567 root [irq/65-ff940000]
0 568 root [card0-crtc0]
0 569 root [card0-crtc1]
0 579 root [brcmf_wq/mmc0:0]
0 586 root [brcmf_wdog/mmc0]
0 588 root [irq/67-panfrost]
0 589 root [pan_js]
0 590 root [pan_js]
0 591 root [pan_js]
0 611 root [cec-dw_hdmi]
0 612 root [irq/65-dw-hdmi-]
0 618 root [kworker/u13:2-hci0]
0 658 root [ext4-rsv-conver]
0 796 root [kworker/3:1-mm_percpu_wq]
0 1866 root [dio/mmcblk2p1]
0 3267 root [kworker/4:1-events_freezable_power_]
0 4157 root [kworker/u12:2]
0 4239 root [kworker/3:2-events]
0 4790 root [kworker/u12:1-flush-252:1]
0 5838 root [kworker/0:0-mm_percpu_wq]
0 7513 root [kworker/3:0H]
0 7563 root [kworker/5:0H]
0 10871 root [kworker/1:1H-kblockd]
0 10872 root [kworker/2:1H]
0 10874 root [kworker/4:1H]
0 12507 root [kworker/0:1H-kblockd]
0 16176 root [kworker/1:1-mm_percpu_wq]
0 16517 root [kworker/1:2H-kblockd]
0 17663 root [kworker/5:1H-kblockd]
0 19998 root [kworker/2:2H-kblockd]
0 22748 root [kworker/5:2-events]
0 25280 root [kworker/3:2H-kblockd]
0 25339 root [kworker/0:2H-kblockd]
0 25501 root [kworker/0:1-mm_percpu_wq]
0 25581 root [kworker/4:2H-kblockd]
0 27140 root [kworker/2:1-events]
0 30477 root [kworker/3:0-mm_percpu_wq]
0 31201 root [kworker/5:0-events]
0 31374 root [kworker/u12:0-events_unbound]
0 31739 root [kworker/4:0-mm_percpu_wq]
0 32091 root [kworker/2:0-events]
Table MB Ligne
historyArch 60.09 745683
cmd 1.97 1432
eqLogic 0.36 122
plan 0.27 312
history 0.17 1162
config 0.13 623
scenario 0.09 29
object 0.09 10
scenarioExpression 0.09 319
scenarioSubElement 0.08 278
widgets 0.08 73
plan3d 0.06 0
viewData 0.05 0
cron 0.05 33
plan3dHeader 0.03 0
viewZone 0.03 0
planHeader 0.03 11
update 0.03 29
listener 0.03 0
dataStore 0.03 11
interactQuery 0.03 0
view 0.03 0
message 0.03 1
jeemate_devices 0.03 20
timeline 0.03 0
user 0.02 0
note 0.02 0
jeemate_DBevent 0.02 0
scenarioElement 0.02 118
interactDef 0.02 0
jeelink_master 0.02 0
jeemate_phone 0.02 0
Et aujourd’hui
SIZE PID USER COMMAND
1411804 1785 mysql /usr/sbin/mysqld
98932 2670 www-data /usr/bin/python3 /var/www/html/plugins/zigbee/resources/zigbeed/zigbeed.py --device /dev/ttyUSB0 --loglevel error --socketport 8089 --callback http://127.0.0.1:80/plugins/zigbee/core/php/jeeZigbee.php --apikey pkbNT36KgB2quKBBa21NpfKyC1KsyWnK --cycle 0.3 --pid /tmp/jeedom/zigbee/deamon_1.pid --data_folder /var/www/html/plugins/zigbee/data/1 --device_folder /var/www/html/plugins/zigbee/data/device --controller ezsp --sub_controller elelabs --channel 15
85152 10762 root /usr/bin/python3 /var/www/html/plugins/blea/resources/blead/blead.py --loglevel error --device hci0 --socketport 55008 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/blea/core/php/jeeBlea.php --apikey x4l21tFpyl8WSsdncwSqhdjyiDVQbAXUZ3tldAjis0a7LJLVWJOy8pbLiTmcgAiw --daemonname local --noseeninterval 4 --scaninterval 29 --scanmode passive --pid /tmp/jeedom/blea/deamon.pid
75488 14661 www-data php /var/www/html/plugins/JeedomConnect/core/class/../../core/php/server.php
62584 2394 www-data /var/www/html/plugins/jMQTT/resources/jmqttd/venv/bin/python3 /var/www/html/plugins/jMQTT/resources/jmqttd/jmqttd.py --loglevel error --callback http://localhost:80/plugins/jMQTT/core/php/callback.php --apikey ct83WUM9hOF0qlBLTi6QPVaI3I8MiBdg --pid /tmp/jeedom/jMQTT/jmqttd.py.pid
54272 691 root /lib/systemd/systemd-journald
50252 1660 root /usr/bin/python3 /usr/bin/fail2ban-server -xf start
43988 2239 root /usr/bin/python3 /var/www/html/plugins/broadlink/resources/broadlinkd/broadlinkd.py --loglevel error --socketport 55013 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/broadlink/core/php/jeeBroadlink.php --apikey YLNMsKXjCyrLvftY0k6NmVLYGCxgeW4E --cycle 0.3 --pid /tmp/jeedom/broadlink/deamon.pid
35776 1474 root /usr/sbin/NetworkManager --no-daemon
31496 2346 www-data php /var/www/html/core/class/../php/jeeCron.php cron_id=34
25840 1790 root /usr/lib/policykit-1/polkitd --no-debug
25368 1659 root /sbin/apcupsd
25176 1449 root /usr/sbin/rngd -r /dev/urandom
21816 1 root /sbin/init
18376 1424 root /usr/sbin/rsyslogd -n -iNONE
16828 1630 root /usr/bin/python3 /usr/share/unattended-upgrades/unattended-upgrade-shutdown --wait-for-signal
16824 32122 www-data /usr/sbin/apache2 -k start
16460 8975 www-data /usr/sbin/apache2 -k start
10080 9325 www-data /usr/sbin/apache2 -k start
9104 25237 www-data php /var/www/html/core/class/../php/jeeCron.php cron_id=1343
8380 31215 www-data /usr/sbin/apache2 -k start
8340 1477 root /usr/bin/python3 /usr/bin/networkd-dispatcher --run-startup-triggers
8228 7862 www-data /usr/sbin/apache2 -k start
8144 6282 www-data /usr/sbin/apache2 -k start
8088 11737 www-data /usr/sbin/apache2 -k start
8036 8131 www-data /usr/sbin/apache2 -k start
8032 10259 www-data /usr/sbin/apache2 -k start
7940 16586 www-data /usr/sbin/apache2 -k start
7444 1800 root /usr/sbin/apache2 -k start
6008 694 root /usr/sbin/haveged --Foreground --verbose=1 -w 1024
5740 1608 mosquit+ /usr/sbin/mosquitto -c /etc/mosquitto/mosquitto.conf
1308 1664 ntp /usr/sbin/ntpd -p /var/run/ntpd.pid -g -u 110:119
1284 1890 root /sbin/dhclient -d -q -sf /usr/lib/NetworkManager/nm-dhcp-helper -pf /run/dhclient-eth0.pid -lf /var/lib/NetworkManager/dhclient-28ba06af-b987-33b2-a264-87ee4b7efb57-eth0.lease -cf /var/lib/NetworkManager/dhclient-eth0.conf eth0
1268 28641 root openvpn --config /tmp/jeedom/openvpn/openvpn_1.ovpn
1264 1462 message+ /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only
1180 26921 www-data ps -eo size,pid,user,command --sort -size
1172 425 root /lib/systemd/systemd-udevd
960 1655 root /usr/sbin/sshd -D
872 1469 root /sbin/wpa_supplicant -u -s -O /run/wpa_supplicant
784 1482 root /lib/systemd/systemd-logind
744 2238 root sudo /usr/bin/python3 /var/www/html/plugins/broadlink/resources/broadlinkd/broadlinkd.py --loglevel error --socketport 55013 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/broadlink/core/php/jeeBroadlink.php --apikey YLNMsKXjCyrLvftY0k6NmVLYGCxgeW4E --cycle 0.3 --pid /tmp/jeedom/broadlink/deamon.pid
744 10761 root sudo /usr/bin/python3 /var/www/html/plugins/blea/resources/blead/blead.py --loglevel error --device hci0 --socketport 55008 --sockethost 127.0.0.1 --callback http://127.0.0.1:80/plugins/blea/core/php/jeeBlea.php --apikey x4l21tFpyl8WSsdncwSqhdjyiDVQbAXUZ3tldAjis0a7LJLVWJOy8pbLiTmcgAiw --daemonname local --noseeninterval 4 --scaninterval 29 --scanmode passive --pid /tmp/jeedom/blea/deamon.pid
744 28634 root sudo openvpn --config /tmp/jeedom/openvpn/openvpn_1.ovpn
692 1475 avahi avahi-daemon: running [JeedomAtlas.local]
592 8122 root /usr/lib/bluetooth/bluetoothd
484 1422 root /usr/sbin/alsactl -E HOME=/run/alsa -s -n 19 -c rdaemon
452 1486 avahi avahi-daemon: chroot helper
444 1448 root /usr/sbin/cron -f
444 1492 daemon /usr/sbin/atd -f
356 26922 root /usr/local/lib/python3.7/dist-packages/bluepy/bluepy-helper 0
344 1670 root /sbin/agetty -o -p -- \u --noclear tty1 linux
324 1600 vnstat /usr/sbin/vnstatd -n
316 26920 www-data sh -c ps -eo size,pid,user,command --sort -size 2>&1
0 2 root [kthreadd]
0 3 root [rcu_gp]
0 4 root [rcu_par_gp]
0 8 root [mm_percpu_wq]
0 9 root [rcu_tasks_kthre]
0 10 root [rcu_tasks_rude_]
0 11 root [rcu_tasks_trace]
0 12 root [ksoftirqd/0]
0 13 root [rcu_preempt]
0 14 root [migration/0]
0 15 root [cpuhp/0]
0 16 root [cpuhp/1]
0 17 root [migration/1]
0 18 root [ksoftirqd/1]
0 21 root [cpuhp/2]
0 22 root [migration/2]
0 23 root [ksoftirqd/2]
0 26 root [cpuhp/3]
0 27 root [migration/3]
0 28 root [ksoftirqd/3]
0 31 root [cpuhp/4]
0 32 root [migration/4]
0 33 root [ksoftirqd/4]
0 36 root [cpuhp/5]
0 37 root [migration/5]
0 38 root [ksoftirqd/5]
0 41 root [kdevtmpfs]
0 42 root [netns]
0 48 root [kauditd]
0 49 root [oom_reaper]
0 50 root [writeback]
0 51 root [kcompactd0]
0 52 root [ksmd]
0 53 root [khugepaged]
0 85 root [cryptd]
0 146 root [kintegrityd]
0 147 root [kblockd]
0 148 root [blkcg_punt_bio]
0 160 root [ata_sff]
0 163 root [edac-poller]
0 164 root [devfreq_wq]
0 165 root [watchdogd]
0 216 root [kswapd0]
0 217 root [ecryptfs-kthrea]
0 220 root [kthrotld]
0 221 root [irq/74-rockchip]
0 222 root [irq/75-rockchip]
0 224 root [nvme-wq]
0 225 root [nvme-reset-wq]
0 226 root [nvme-delete-wq]
0 227 root [vfio-irqfd-clea]
0 228 root [irq/78-rk808]
0 229 root [irq/48-rockchip]
0 230 root [bch_btree_io]
0 231 root [bcache]
0 232 root [bch_journal]
0 235 root [kworker/u13:0-hci0]
0 236 root [sdhci]
0 237 root [irq/38-mmc2]
0 238 root [irq/88-fe320000]
0 242 root [ipv6_addrconf]
0 249 root [mmc_complete]
0 254 root [kstrp]
0 257 root [zswap1]
0 258 root [zswap1]
0 259 root [zswap-shrink]
0 316 root [stmmac_wq]
0 349 root [jbd2/mmcblk2p1-]
0 350 root [ext4-rsv-conver]
0 549 root [cfg80211]
0 562 root [irq/54-ff660000]
0 567 root [irq/65-ff940000]
0 568 root [card0-crtc0]
0 569 root [card0-crtc1]
0 579 root [brcmf_wq/mmc0:0]
0 586 root [brcmf_wdog/mmc0]
0 588 root [irq/67-panfrost]
0 589 root [pan_js]
0 590 root [pan_js]
0 591 root [pan_js]
0 611 root [cec-dw_hdmi]
0 612 root [irq/65-dw-hdmi-]
0 658 root [ext4-rsv-conver]
0 766 root [kworker/2:2H]
0 1010 root [kworker/u12:1-events_unbound]
0 1866 root [dio/mmcblk2p1]
0 4447 root [kworker/5:1H-kblockd]
0 4807 root [kworker/2:1-events]
0 5562 root [kworker/1:2H-kblockd]
0 6084 root [kworker/4:0H-kblockd]
0 8124 root [kworker/u13:1-hci0]
0 8566 root [kworker/0:1H-kblockd]
0 8817 root [kworker/0:2H-kblockd]
0 8870 root [kworker/3:2H]
0 8871 root [kworker/4:2H]
0 9517 root [kworker/3:0H-kblockd]
0 11839 root [kworker/1:1H-kblockd]
0 12093 root [kworker/4:2-pm]
0 12752 root [kworker/u12:2-cfg80211]
0 12999 root [kworker/5:0H-kblockd]
0 14288 root [apccontrol]
0 14835 root [kworker/3:0-mm_percpu_wq]
0 16347 root [kworker/1:1-mm_percpu_wq]
0 17459 root [kworker/4:0-events]
0 17479 root [kworker/0:2-pm]
0 18219 root [kworker/5:2-mm_percpu_wq]
0 19141 root [kworker/5:0-events]
0 20130 root [kworker/3:1-events_power_efficient]
0 20236 root [kworker/2:2-pm]
0 21492 root [kworker/1:0-mm_percpu_wq]
0 22362 root [kworker/4:1-events]
0 22416 root [kworker/u12:0-ext4-rsv-conversion]
0 23934 root [kworker/0:0-events]
0 24772 root [kworker/0:1-events]
0 24807 root [kworker/5:1-events]
0 25000 root [kworker/2:0-events]
0 25151 root [kworker/3:2-events_power_efficient]
0 25203 root [kworker/3:3-events_power_efficient]
0 32310 root [kworker/2:0H-kblockd]
Table MB Ligne
historyArch 61.09 736170
cmd 1.92 1419
eqLogic 0.39 128
plan 0.27 313
config 0.13 647
scenario 0.09 30
history 0.09 1148
scenarioExpression 0.09 351
object 0.09 10
widgets 0.08 77
scenarioSubElement 0.08 296
plan3d 0.06 0
viewData 0.05 0
cron 0.05 29
viewZone 0.03 0
update 0.03 33
dataStore 0.03 12
interactQuery 0.03 1
message 0.03 2
jeemate_devices 0.03 20
planHeader 0.03 10
timeline 0.03 0
listener 0.03 1
view 0.03 0
plan3dHeader 0.03 0
user 0.02 0
scenarioElement 0.02 133
jeemate_DBevent 0.02 0
blea_remote 0.02 0
interactDef 0.02 1
jeelink_master 0.02 0
jeemate_phone 0.02 0
note 0.02 0
Merci d’avance
Hello @stouph19,
Tu as des nouvelles de ton ticket ?
Peux-tu me redonner le résultat de la requête SQL suivante : SHOW FULL PROCESSLIST;
Puis le résultat de la requête SHOW TABLE STATUS
Et un ordre de grandeur des connexions ouvertes (commande shell netstat -an
)`
Mais là je sèche un peu…
Si tu as fait des montées de versions successives sur ce système, peut-être est-il temps de refaire une installation de zero et restaurer un backup, comme signalé par JeedAlf ici :
Bad
ah doit y avoir erreur , Je n’ai jamais ouvert de ticket car je ne suis pas Sebastien, c’est un autre post.
Par contre voici les requêtes :
SHOW FULL PROCESSLIST:
21 jeedom localhost jeedom Sleep 13 null 0.000
620857 jeedom localhost jeedom Sleep 0 null 0.000
680814 jeedom localhost jeedom Sleep 5 null 0.000
688143 jeedom localhost jeedom Sleep 0 null 0.000
688231 jeedom localhost jeedom Sleep 0 null 0.000
688255 jeedom localhost jeedom Sleep 0 null 0.000
688271 jeedom localhost jeedom Sleep 2 null 0.000
688314 jeedom localhost jeedom Sleep 0 null 0.000
688503 jeedom localhost jeedom Sleep 1 null 0.000
689945 jeedom localhost jeedom Sleep 5 null 0.000
689946 jeedom localhost jeedom Query 0 Init SHOW FULL PROCESSLIST 0.000
689999 jeedom localhost jeedom Sleep 1 null 0.000
690000 jeedom localhost jeedom Sleep 2 null 0.000
690001 jeedom localhost jeedom Sleep 5 null 0.000
690022 jeedom localhost jeedom Sleep 5 null 0.000
Show table status:
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary
blea_remote InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2022-09-01 18:30:45 null null utf8_general_ci null 0 N
cmd InnoDB 10 Dynamic 1419 1119 1589248 0 425984 2097152 7735 2022-10-01 02:57:09 2022-10-01 09:01:46 null utf8mb4_general_ci null 0 N
config InnoDB 10 Dynamic 647 202 131072 0 0 0 null 2022-06-25 11:39:55 2022-10-01 08:49:34 null utf8mb4_general_ci null 0 N
cron InnoDB 10 Dynamic 29 564 16384 0 32768 0 8430 2022-06-25 11:39:55 2022-10-01 09:43:02 null utf8mb4_general_ci null 0 N
dataStore InnoDB 10 Dynamic 12 1365 16384 0 16384 0 18 2022-06-25 11:39:55 2022-10-01 03:31:07 null utf8mb4_general_ci null 0 N
eqLogic InnoDB 10 Dynamic 128 2176 278528 0 131072 0 546 2022-06-25 11:39:55 2022-10-01 09:42:51 null utf8mb4_general_ci null 0 N
history InnoDB 10 Dynamic 1200 54 65536 0 32768 0 null 2022-09-10 02:57:09 2022-10-01 09:45:04 null utf8mb4_general_ci null 0 N
historyArch InnoDB 10 Dynamic 736170 69 50937856 0 13123584 7340032 null 2022-10-01 02:57:09 2022-10-01 05:00:08 null utf8mb4_general_ci null 0 N
interactDef InnoDB 10 Dynamic 1 16384 16384 0 0 0 3 2022-06-25 11:40:08 2022-09-01 08:38:23 null utf8mb4_general_ci null 0 N
interactQuery InnoDB 10 Dynamic 1 16384 16384 0 16384 0 13 2022-06-25 11:40:08 2022-09-01 08:38:43 null utf8mb4_general_ci null 0 N
jeelink_master InnoDB 10 Dynamic 0 0 16384 0 0 0 2 2022-06-25 11:40:08 null null utf8_general_ci null 0 N
jeemate_DBevent InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2022-08-04 05:35:22 null null utf8mb4_general_ci null 0 N
jeemate_devices InnoDB 10 Dynamic 20 819 16384 0 16384 0 21 2022-08-04 05:35:22 null null utf8_general_ci null 0 N
jeemate_phone InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2022-08-04 05:35:22 null null utf8mb4_general_ci null 0 N
listener InnoDB 10 Dynamic 1 16384 16384 0 16384 0 6 2022-06-25 11:40:08 2022-09-21 07:57:28 null utf8mb4_general_ci null 0 N
message InnoDB 10 Dynamic 2 8192 16384 0 16384 0 718 2022-06-25 11:40:08 2022-09-29 14:55:03 null utf8mb4_general_ci null 0 N
note InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2022-06-25 11:40:08 null null utf8mb4_general_ci null 0 N
object InnoDB 10 Dynamic 10 4915 49152 0 49152 0 11 2022-06-25 11:40:08 null null utf8mb4_general_ci null 0 N
plan InnoDB 10 Dynamic 313 785 245760 0 32768 0 923 2022-06-25 11:40:08 2022-09-15 11:19:14 null utf8mb4_general_ci null 0 N
plan3d InnoDB 10 Dynamic 0 0 16384 0 49152 0 1 2022-06-25 11:40:08 null null utf8mb4_general_ci null 0 N
plan3dHeader InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2022-06-25 11:40:08 null null utf8mb4_general_ci null 0 N
planHeader InnoDB 10 Dynamic 10 1638 16384 0 16384 0 23 2022-06-25 11:40:08 2022-09-07 05:33:05 null utf8mb4_general_ci null 0 N
scenario InnoDB 10 Dynamic 30 546 16384 0 81920 0 55 2022-06-25 11:40:08 2022-10-01 07:51:17 null utf8mb4_general_ci null 0 N
scenarioElement InnoDB 10 Dynamic 133 123 16384 0 0 0 248 2022-06-25 11:40:08 2022-09-28 08:14:58 null utf8mb4_general_ci null 0 N
scenarioExpression InnoDB 10 Dynamic 351 233 81920 0 16384 0 745 2022-06-25 11:40:08 2022-09-30 17:08:10 null utf8mb4_general_ci null 0 N
scenarioSubElement InnoDB 10 Dynamic 296 166 49152 0 32768 0 586 2022-06-25 11:40:08 2022-10-01 09:25:32 null utf8mb4_general_ci null 0 N
timeline InnoDB 10 Dynamic 0 0 16384 0 16384 0 1809 2022-07-24 02:57:09 null null utf8mb4_general_ci null 0 N
update InnoDB 10 Dynamic 33 496 16384 0 16384 0 63 2022-06-25 11:40:08 2022-10-01 06:55:16 null utf8mb4_general_ci null 0 N
user InnoDB 10 Dynamic 0 0 16384 0 0 0 2 2022-06-25 11:40:09 2022-10-01 09:35:35 null utf8mb4_general_ci null 0 N
view InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2022-06-25 11:40:09 null null utf8mb4_general_ci null 0 N
viewData InnoDB 10 Dynamic 0 0 16384 0 32768 0 1 2022-06-25 11:40:09 null null utf8mb4_general_ci null 0 N
viewZone InnoDB 10 Dynamic 0 0 16384 0 16384 0 1 2022-06-25 11:40:09 null null utf8mb4_general_ci null 0 N
widgets InnoDB 10 Dynamic 77 851 65536 0 16384 0 106 2022-06-25 11:40:09 2022-09-28 08:07:40 null utf8mb4_general_ci null 0 N
et enfin netstat:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 127.0.0.1:3551 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:55008 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:55013 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:36455 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:8089 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:8090 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:1883 0.0.0.0:* LISTEN
tcp 0 0 192.168.1.60:1883 192.168.1.107:56679 ESTABLISHED
tcp 0 0 192.168.1.60:55324 192.168.1.108:2323 TIME_WAIT
tcp 0 0 192.168.1.60:41652 192.168.1.111:2323 TIME_WAIT
tcp 0 0 192.168.1.60:1883 192.168.1.122:52709 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.117:50636 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.120:52793 ESTABLISHED
tcp 0 0 192.168.1.60:41646 192.168.1.111:2323 TIME_WAIT
tcp 0 0 192.168.1.60:1883 192.168.1.119:62266 ESTABLISHED
tcp 0 0 127.0.0.1:51264 127.0.0.1:1883 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.126:57110 ESTABLISHED
tcp 0 0 127.0.0.1:1883 127.0.0.1:51264 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.111:38903 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.101:55169 ESTABLISHED
tcp 0 0 127.0.0.1:49852 127.0.0.1:36455 TIME_WAIT
tcp 0 0 192.168.1.60:8090 104.152.52.101:55806 ESTABLISHED
tcp 0 0 127.0.0.1:40184 127.0.0.1:36057 ESTABLISHED
tcp 0 0 192.168.1.60:8090 179.60.150.88:61762 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.129:51858 ESTABLISHED
tcp 0 0 192.168.1.60:55448 192.168.1.108:2323 ESTABLISHED
tcp 0 0 192.168.1.60:8090 198.23.149.111:41477 ESTABLISHED
tcp 0 0 192.168.1.60:8090 77.205.52.170:42910 ESTABLISHED
tcp 0 1 192.168.1.60:33872 192.168.1.114:90 SYN_SENT
tcp 0 0 192.168.1.60:1883 192.168.1.123:60359 ESTABLISHED
tcp 0 0 192.168.1.60:8090 90.12.232.206:42908 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.108:60202 ESTABLISHED
tcp 0 0 192.168.1.60:8090 104.152.52.91:57857 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.125:50693 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.106:62750 ESTABLISHED
tcp 0 0 127.0.0.1:36057 127.0.0.1:40184 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.102:57122 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.124:64484 ESTABLISHED
tcp 0 0 192.168.1.60:1883 192.168.1.118:61256 ESTABLISHED
tcp 0 0 192.168.1.60:41650 192.168.1.111:2323 TIME_WAIT
tcp 0 0 192.168.1.60:8090 77.205.53.176:43142 ESTABLISHED
tcp 0 0 192.168.1.60:8090 123.160.221.21:38340 ESTABLISHED
tcp 0 0 192.168.1.60:55336 192.168.1.108:2323 TIME_WAIT
tcp 0 0 127.0.0.1:55260 127.0.0.1:80 TIME_WAIT
tcp 0 0 192.168.1.60:8090 192.168.1.109:41136 ESTABLISHED
tcp 0 0 127.0.0.1:55252 127.0.0.1:80 TIME_WAIT
tcp 0 0 127.0.0.1:55204 127.0.0.1:80 TIME_WAIT
tcp 0 0 192.168.1.60:1883 192.168.1.104:55842 ESTABLISHED
tcp6 0 0 :::80 :::* LISTEN
tcp6 0 0 :::22 :::* LISTEN
tcp6 0 0 :::1883 :::* LISTEN
tcp6 0 0 ::1:49113 ::1:1883 ESTABLISHED
tcp6 0 0 ::1:58154 ::1:80 TIME_WAIT
tcp6 0 0 192.168.1.60:80 192.168.1.21:50114 TIME_WAIT
tcp6 0 0 ::1:58176 ::1:80 TIME_WAIT
tcp6 0 0 192.168.1.60:80 192.168.1.21:50115 TIME_WAIT
tcp6 0 0 ::1:58242 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58220 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58250 ::1:80 TIME_WAIT
tcp6 0 0 ::1:1883 ::1:49113 ESTABLISHED
tcp6 0 0 ::1:58180 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58168 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58216 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58164 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58194 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58134 ::1:80 TIME_WAIT
tcp6 0 0 192.168.1.60:80 192.168.1.21:50074 ESTABLISHED
tcp6 0 0 192.168.1.60:80 192.168.1.21:50117 ESTABLISHED
tcp6 0 0 ::1:58232 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58204 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58138 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58136 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58208 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58200 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58160 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58186 ::1:80 TIME_WAIT
tcp6 0 0 ::1:58224 ::1:80 TIME_WAIT
tcp6 0 0 192.168.1.60:80 192.168.1.21:50116 TIME_WAIT
udp 0 0 0.0.0.0:35891 0.0.0.0:*
udp 0 0 0.0.0.0:5353 0.0.0.0:*
udp 0 0 0.0.0.0:58711 0.0.0.0:*
udp 0 0 0.0.0.0:68 0.0.0.0:*
udp 0 0 10.13.1.74:123 0.0.0.0:*
udp 0 0 192.168.1.60:123 0.0.0.0:*
udp 0 0 127.0.0.1:123 0.0.0.0:*
udp 0 0 0.0.0.0:123 0.0.0.0:*
udp6 0 0 :::5353 :::*
udp6 0 0 :::53205 :::*
udp6 0 0 fe80::9071:2b35:2a1:123 :::*
udp6 0 0 fe80::c9c:ddff:fea0:123 :::*
udp6 0 0 2a01:cb18:2c4:2300::123 :::*
udp6 0 0 ::1:123 :::*
udp6 0 0 :::123 :::*
raw 0 768 0.0.0.0:1 0.0.0.0:* 7
raw6 0 0 :::58 :::* 7
Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node Path
unix 3 [ ] DGRAM 9776 /run/systemd/notify
unix 2 [ ACC ] STREAM LISTENING 9779 /run/systemd/private
unix 2 [ ] DGRAM 9784 /run/systemd/journal/syslog
unix 2 [ ACC ] STREAM LISTENING 9795 /run/systemd/fsck.progress
unix 2 [ ACC ] STREAM LISTENING 9797 /run/systemd/journal/stdout
unix 5 [ ] DGRAM 9799 /run/systemd/journal/socket
unix 17 [ ] DGRAM 17135 /run/systemd/journal/dev-log
unix 2 [ ACC ] STREAM LISTENING 10191 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] SEQPACKET LISTENING 17140 /run/udev/control
unix 2 [ ACC ] STREAM LISTENING 10194 /run/avahi-daemon/socket
unix 2 [ ] DGRAM 24375 /run/wpa_supplicant/wlan0
unix 2 [ ] DGRAM 21271 /run/wpa_supplicant/p2p-dev-wlan0
unix 2 [ ACC ] STREAM LISTENING 21283 /var/run/fail2ban/fail2ban.sock
unix 2 [ ACC ] STREAM LISTENING 24727 /run/mysqld/mysqld.sock
unix 2 [ ACC ] STREAM LISTENING 23490 /run/NetworkManager/private-dhcp
unix 3 [ ] DGRAM 18826
unix 2 [ ] DGRAM 26231
unix 2 [ ] DGRAM 18752
unix 3 [ ] STREAM CONNECTED 26228 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 18163 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 230204252
unix 2 [ ] DGRAM 159405676
unix 3 [ ] STREAM CONNECTED 37690252
unix 3 [ ] STREAM CONNECTED 230211273 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 29130
unix 2 [ ] DGRAM 18949
unix 2 [ ] DGRAM 37703001
unix 3 [ ] STREAM CONNECTED 22380 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 25161 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 18948
unix 3 [ ] STREAM CONNECTED 26227
unix 3 [ ] DGRAM 18827
unix 2 [ ] STREAM CONNECTED 159381296
unix 2 [ ] DGRAM 19075
unix 3 [ ] STREAM CONNECTED 18095 /run/systemd/journal/stdout
unix 2 [ ] STREAM CONNECTED 28778
unix 3 [ ] STREAM CONNECTED 200394109 /run/mysqld/mysqld.sock
unix 2 [ ] STREAM CONNECTED 159381382
unix 2 [ ] STREAM CONNECTED 125801232
unix 3 [ ] STREAM CONNECTED 19074
unix 3 [ ] STREAM CONNECTED 19206
unix 2 [ ] DGRAM 19144
unix 3 [ ] STREAM CONNECTED 19432
unix 3 [ ] STREAM CONNECTED 200393248
unix 3 [ ] STREAM CONNECTED 37691965 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 230167898 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 230211810 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 19333 /run/systemd/journal/stdout
unix 3 [ ] DGRAM 17333
unix 3 [ ] STREAM CONNECTED 229424625 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 229467109
unix 2 [ ] DGRAM 17925
unix 3 [ ] DGRAM 17332
unix 3 [ ] STREAM CONNECTED 229414756
unix 3 [ ] STREAM CONNECTED 18235
unix 2 [ ] STREAM CONNECTED 223905865
unix 3 [ ] STREAM CONNECTED 19424
unix 2 [ ] DGRAM 19420
unix 2 [ ] DGRAM 17330
unix 3 [ ] STREAM CONNECTED 229584382
unix 3 [ ] STREAM CONNECTED 230166143
unix 3 [ ] STREAM CONNECTED 19330
unix 3 [ ] STREAM CONNECTED 230167935 /run/mysqld/mysqld.sock
unix 2 [ ] DGRAM 19338
unix 2 [ ] STREAM CONNECTED 31731353
unix 3 [ ] STREAM CONNECTED 229469408 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 19331 /run/systemd/journal/stdout
unix 2 [ ] DGRAM 18096
unix 3 [ ] STREAM CONNECTED 18160
unix 3 [ ] STREAM CONNECTED 17328
unix 3 [ ] STREAM CONNECTED 23010 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 18805 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 230166214
unix 3 [ ] STREAM CONNECTED 19431
unix 2 [ ] STREAM CONNECTED 230207909
unix 3 [ ] STREAM CONNECTED 229588630 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 19435 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 230207973
unix 3 [ ] STREAM CONNECTED 21032
unix 3 [ ] STREAM CONNECTED 31824
unix 3 [ ] STREAM CONNECTED 24706 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 23339
unix 3 [ ] STREAM CONNECTED 21098
unix 3 [ ] STREAM CONNECTED 27373
unix 3 [ ] STREAM CONNECTED 23997
unix 3 [ ] STREAM CONNECTED 23338
unix 3 [ ] STREAM CONNECTED 19433 /var/run/dbus/system_bus_socket
unix 2 [ ] DGRAM 23903
unix 2 [ ] STREAM CONNECTED 34353556
unix 3 [ ] STREAM CONNECTED 18313 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 25442
unix 3 [ ] STREAM CONNECTED 26447 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 25443
unix 3 [ ] STREAM CONNECTED 31823
unix 3 [ ] STREAM CONNECTED 27360
unix 2 [ ] DGRAM 27849
unix 3 [ ] STREAM CONNECTED 23911 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 23188
unix 3 [ ] STREAM CONNECTED 34487
unix 3 [ ] DGRAM 9778
unix 2 [ ] DGRAM 27659
unix 3 [ ] STREAM CONNECTED 21267
unix 3 [ ] STREAM CONNECTED 24371 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 34488
unix 3 [ ] DGRAM 9777
unix 3 [ ] STREAM CONNECTED 21266
unix 3 [ ] STREAM CONNECTED 24292
unix 2 [ ] DGRAM 21143
unix 3 [ ] STREAM CONNECTED 24293
unix 3 [ ] STREAM CONNECTED 19332 /run/systemd/journal/stdout
unix 2 [ ] STREAM CONNECTED 27426
unix 3 [ ] STREAM CONNECTED 229478848
unix 3 [ ] STREAM CONNECTED 230149100 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 27299 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 22464
unix 3 [ ] STREAM CONNECTED 27298
unix 3 [ ] STREAM CONNECTED 230149108 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 23020 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 229486678
unix 3 [ ] STREAM CONNECTED 26837
unix 2 [ ] DGRAM 230212782
unix 3 [ ] STREAM CONNECTED 24707
unix 3 [ ] STREAM CONNECTED 229507071
unix 3 [ ] STREAM CONNECTED 24579
unix 2 [ ] STREAM CONNECTED 31733212
unix 3 [ ] STREAM CONNECTED 24580
unix 2 [ ] DGRAM 27317
unix 3 [ ] STREAM CONNECTED 230167972 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 230149343
unix 3 [ ] STREAM CONNECTED 19436 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 229507809 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 37692860 /var/run/dbus/system_bus_socket
unix 2 [ ] DGRAM 24586
unix 3 [ ] STREAM CONNECTED 26111 /run/systemd/journal/stdout
unix 2 [ ] DGRAM 37693456
unix 3 [ ] STREAM CONNECTED 19434 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 230164907
unix 3 [ ] STREAM CONNECTED 24584
unix 3 [ ] STREAM CONNECTED 229480570 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 18832 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 37693458
unix 3 [ ] STREAM CONNECTED 24594
unix 3 [ ] STREAM CONNECTED 230147910
unix 3 [ ] STREAM CONNECTED 26017 /run/systemd/journal/stdout
unix 3 [ ] STREAM CONNECTED 22107
unix 3 [ ] STREAM CONNECTED 229485651 /run/mysqld/mysqld.sock
unix 3 [ ] STREAM CONNECTED 27090
Désolé de vous embêtez un samedi
En effet, toutes mes excuses ^^
J’ai l’impression qu’il y a un truc très gros dans historyArch, peux-tu lancer cette requête stp :
SELECT cmd_id, COUNT(value) AS nb, SUM(LENGTH(value)) AS taille FROM historyArch GROUP BY cmd_id ORDER BY taille DESC
(Nombre et taille totale des historiques par commande)
Et une petite capture de la page de santé et des plugins installée aussi ?
Sinon le reste semble normal…
Si tu redémarres 1 plugin différent toutes les 5-10 minutes, tu verras peut-être celui qui fait mal à ce point là à mySQL ?
Ou ça n’a rien à voir avec un plugin ? et il faut que tu reboot complètement pour résoudre ?
Merci,
Bad
Je suis désolé comment je fait cette requête:
Je ne suis pas trés douer
Voici les captures:
et moteur de taches , si ça peut aider:
La aussi semble normal…
Tu peux lancer la requête au même endroit que tu as fais :
Si tu redémarres 1 plugin différent toutes les 5-10 minutes, tu verras peut-être celui qui fait mal à ce point là à mySQL ? Ou ça n’a rien à voir avec un plugin ? et il faut que tu reboot complètement pour résoudre ?
Et voici:
cmd_id nb taille
1330 469798 18049030
2515 4521 49731
2516 4521 49731
2517 4521 49731
140 6793 44850
1459 3157 37884
39 928 35924
3836 29615 29615
3837 29615 29615
3835 29615 29615
3860 29609 29609
3869 29608 29608
3870 29608 29608
3871 29608 29608
3868 29608 29608
3777 1739 6194
2519 2872 5744
137 273 2133
139 273 2100
138 273 1905
5469 127 1865
5184 144 1728
141 273 1678
215 141 1669
3676 1105 1626
5183 135 1620
3663 344 1302
6966 54 707
6969 54 700
6964 54 678
6965 54 678
6967 54 674
6960 54 670
6961 54 664
6956 54 648
6963 54 626
6968 54 626
6962 54 626
6957 54 594
6958 54 594
6959 54 594
2237 506 506
2758 25 300
1866 25 300
1677 24 288
3822 23 276
2755 25 275
2756 25 275
2757 25 275
6955 54 266
3821 18 216
5204 178 178
3839 103 103
3840 103 103
3872 103 103
3841 103 103
3873 103 103
3874 103 103
3861 103 103
3875 103 103
2238 88 88
5074 84 84
6558 3 36
1069 3 33
1173 30 30
1154 30 30
5098 2 26
5100 2 24
2050 18 18
775 2 15
5640 1 14
1423 1 14
5729 14 14
306 1 14
5642 1 13
1071 1 13
5173 1 13
1425 1 13
6555 1 13
7724 2 12
7723 2 12
5171 1 11
2236 10 10
1852 6 6
2213 6 6
1146 6 6
751 6 6
41 4 4
6530 3 3
3338 2 2
7725 2 2
1045 2 2
1155 1 1
777 1 1
5616 1 1
1993 1 1
5147 1 1
1399 1 1
2214 1 1
1147 1 1
A quoi correspond ta commande #1330#
?
Elle est clairement en train d’exploser.
Si tu redémarres 1 plugin différent toutes les 5-10 minutes, tu verras peut-être celui qui fait mal à ce point là à mySQL ? Ou ça n’a rien à voir avec un plugin ? et il faut que tu reboot complètement pour résoudre ?
Ah je sent que tu va trouvé mon souci.
quand je fais une recherche par ID cela correspond a la commande « position » du pluging « Jeedomconnect » du téléphone de ma femme.
Alors il faudrait faire le ménage dans les positions de ta femme (2 jokes-inside).
OK merci je vais essayer de faire le ménage ( je ne sait pas comment faire mais je vais essayer)
en tous les cas merci de ta patience , bon week end
Clique simplement sur la la petite roue verte à droite et regarde comment est-ce que c’est historisé.
Si tu le souhaites tu peux vider l’historique,
mais c’est peut-être mieux de simplement réduire la durée de conservation.
Si c’est du texte qui est stocké (type autre), c’est normal que ça prenne de la place, mais il faudrait voir avec un dev de JC le pourquoi du comment.
Pas sur que ce soit la raison de tous tes maux non plus…
Le souci c’est que la commande n’a jamais été historisé. mais cela est peut etre fait autrement .
Je suis en train de recherché des posts concernant la commande « position » du plugin jeedom connect sur le forum
Bonjour,
Par défaut la commande position de JC n’est pas historisée sauf erreur; en tout cas elle ne l’est pas chez moi.
Donc si elle l’est, c’est que la case « historisé » de la commande est coché chez vous => décochez la case.
Bonjour,
Je voulais dire que quand je vais voir la commande « position » de JC la case « historisé » n’est pas coché, et ne l’a jamais été.
Hum, curieux ça; vous êtes sur que vous ne l’avez jamais cochée même temporairement ?
Cochez la case alors pour tester et allez voir dans l’historique ce que vous y trouvez.
De toute façon c’est le core qui gère l’historique, ça ne dépend pas du plug-in.