In this chapter, we dove deeper into the internal data structures Zabbix uses. While that's still just a small part of a large amount of database, XML import/export, API, and other information, it should help with some of the common problems users encounter at first.
We figured out how to get raw data from the frontend, which is the easiest method for small datasets. For bigger amounts of data, we learned how to grab data from different history tables, depending on data type. We also found out how Zabbix proxies keep data in their local databases. For situations where less precision is needed, we learned about the trends table and the calculation of the hourly minimal, maximal, and average values that're stored there. We also covered resetting user passwords directly in the database and fixing item history values if the item configuration was incorrect initially...
