Thanks for the hint, enabled it but still getting the same output:
MariaDB [(none)]> show variables like '%status%'; +----------------------------------+-------+ | Variable_name | Value | +----------------------------------+-------+ | innodb_buf_dump_status_frequency | 0 | | innodb_status_output | ON | | innodb_status_output_locks | ON | +----------------------------------+-------+ 3 rows in set (0.001 sec)
Any other hints or things i might missing?
Thanks, Alex
From: Michael Kelly michael@swiftserve.com Sent: Thursday, 16 September 2021 11:57 To: Observium observium@observium.org Cc: Joelly, Alexander Alexander.Joelly@magna.com Subject: Re: [Observium] MySQL/MariaDB monitoring
WARNING: This e-mail originated from outside of Magna. Be cautious with links and attachments. ________________________________ If I remember correctly, I think you need to enable InnoDB monitoring in MySQL as it is disabled by default. See https://dev.mysql.com/doc/refman/8.0/en/innodb-enabling-monitors.html for details.
Hope this helps, Michael.
On Thu, 16 Sept 2021 at 10:43, Joelly, Alexander via observium <observium@observium.orgmailto:observium@observium.org> wrote:
The MySQL App graphs on my Observium host only graphing the MySQL System & Queries but nothing for innoDB except the InnoDB Log
Is the anything additionally to set to get the other graphs working as well?
running the mysql query script locally gives following output: <<<mysql>>> a0:8 a1:4 a2:0 a3:0 a4:-1 a5:-1 a6:-1 a7:-1 a8:-1 a9:-1 aa:-1 ab:-1 ac:-1 ad:-1 ae:-1 af:-1 ag:-1 ah:-1 ai:-1 aj:-1 ak:-1 al:-1 am:-1 an:-1 ao:-1 ap:-1 aq:-1 ar:-1 as:-1 at:-1 au:-1 av:-1 aw:-1 ax:-1 ay:-1 az:-1 b0:-1 b1:-1 b2:-1 b3:-1 b4:0 b5:19 b6:0 b7:25 b8:284 b9:291 ba:2000 bb:32768 bc:2000 bd:0 be:3 bf:194 bg:0 bh:61 bi:133 bj:194 bk:7 bl:8192 bm:256 bn:44136 bo:-1 bp:-1 bq:0 br:-1 bs:0 bt:2247 bu:7249176 bv:931561 bw:1703944 bx:494047 by:99150 bz:5422 c0:13171 c1:16777216 c2:5988535 c3:2979656 c4:98399 c5:2734348 c6:43840 c7:0 c8:0 c9:0 ca:0 cb:0 cc:0 cd:35 ce:0 cf:19345 cg:0 ch:83601 ci:0 cj:49873 ck:538619 cl:694 cm:49775 cn:350 co:5 cp:12001694929 cq:1592734939 cr:16777216 cs:-1 ct:-1 cu:-1 cv:-1 cw:32768 cx:0 cy:0 cz:-1 d0:-1 d1:-1 d2:-1 d3:-1 d4:-1 d5:-1 d6:1 d7:-1 d8:-1 d9:-1 da:-1 db:-1 dc:-1 dd:-1 de:-1 df:-1 dg:-1 dh:-1 di:4836614 dj:124200 dk:0 dl:0 dm:1745 dn:7100602 do:83835892 dp:1394 dq:1697321 dr:77390433 ds:0 dt:0 du:0 dv:3953279 dw:1118301 dx:-1 dy:-1 dz:-1 e0:-1 e1:-1 e2:-1 e3:-1 e4:-1 e5:-1 e6:-1 e7:-1 e8:-1 e9:-1 ea:-1 eb:-1 ec:-1 ed:-1 ee:-1 ef:-1 eg:0 eh:24486912 ei:134217728 ej:12453 ek:2840
thx, Alex _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium