[MDEV-20705] MariaDB 10.3.13 and Zabbix 4.2.1 Compatibility Created: 2019-10-01  Updated: 2019-10-02  Resolved: 2019-10-02

Status: Closed
Project: MariaDB Server
Component/s: Variables
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Yeongin JUNG Assignee: Faustin Lammler
Resolution: Not a Bug Votes: 0
Labels: Compatibility
Environment:

MariaDB version: 10.3.13
Zabbix version: 4.2.1

Attachments: PNG File global.PNG     PNG File threads.PNG    

 Description   

I am using MariaDB version: 10.3.13 and Zabbix version: 4.2.1.
I upgraded MariaDB 10.3.13 version from 10.2.19 and I found out a problem.

When I used 10.2.19 with Zabbix together, Zabbix only took the value of real threads_running status (active session) without daemon or sleep status. But after the upgrading, zabbix collects all status including daemon and sleep status even though the actual running session is only one.

So I compared with another MariaDB server which is version 10.2.19 and it shows only session without daemon and sleep status.

So here is what Zabbix actually take from DB.
10.2.19 -> show status like '%threads_running%';
10.3.13 -> show global status like '%threads_running%';

So, I wanna collect threads_running status which is really running.
Is there any solution for this problem?



 Comments   
Comment by Faustin Lammler [ 2019-10-02 ]

Hi duddls2054, thank you for your report.

Unfortunately, I don't see any bug here and anything related with MariaDB,

You may consider asking help directly at the zabbix community and see what modification you should do to your MySQL template?
https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql

Regards,
Faustin

Generated at Thu Feb 08 09:01:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.