Database performance items

Database performance items are very important points and are overlooked by some users. We emphasize the importance of knowing the Zabbix server internally to get a correct reading of the data, and thereby make good corrective actions. We also need to know the Zabbix database parameters that can help us when making decisions and adjustments to the environment.

Each database has its peculiarity, and we must turn to the experts we have at home to support us with the data that we should collect and show us how we should evaluate that data.

As we have spoken of MySQL throughout this book, it is on this basis that we will address this topic. The trick is to use a MySQL collector that already has a ready metric and in which it is easy to incorporate new collections. Currently, DBforBIX is the most versatile gatherer that we can use to work with Zabbix. Its download and more information are available on the DBforBIX site at http://www.smartmarmot.com/product/dbforbix/.

The...