Retrieve CPU load, CPU utilization, Memory utilization, Disk space usage frm Mysql DB

[vamshi_pulluri]

I am using Zabbix 4.0 with Mysql database. After reading many posts and literature, I realized that Zabbix monitors data related to different metrics. I am doing a project in which I have to create a Machine Learning model from the monitored data. To create the Machine Learning model I need data related to CPU load, CPU utilization, Memory utilization, and Disk space. Mysql database has different Tables and each table has different columns. However, there was no column that is related to the above-said metrics. So, I assume these metrics are stored in an indirect way in the Mysql database. I want to know how to retrieve these metrics from the Mysql database for Machine Learning model. If possible, I also want to know how to understand the storing mechanism of Zabbix. Any help is appreciated.

[Andrzej PAwlik]

Try use Zabbix API to get data from database.

[vamshi_pulluri]

Hi @Andrzej PAwlik Yes, I realized that I should use Zabbix API. However, I could not understand how the above-said metrics could be retrieved from the database schema. Any documentation or forum post on decoding this would be helpful.

[Andrzej PAwlik]

API history.get -> raw data on Item if you know itemids.

https://www.zabbix.com/documentation/4.0/manual/api/reference/history/get

API trend get

https://www.zabbix.com/documentation/4.0/manual/api/reference/trend/get

and this have you database schema

https://zabbix.org/wiki/Docs/DB_schema/4.0