oli's blog

Hi John,

MPM can work with any MySQL branch/fork. Some of the branches try to make their product unique by adding features or changing things. Because we are parsing the output of SHOW ENGINE INNODB STATUS amongst other things some values can become wrong over time when the output format is changed by the vendors.

Daniel the Hazard wrote us:

just wanted to leave this complement to your GLB post: a init script for GLB that supports adding and removing targets

See also Byobu.

Often support customers want to see what you do on their databases. For this screen is the ideal tool.

Some updates if you want to use bonding on CentOS 6:

Dear MySQL User,

With this newsletter we bring you up to date about MySQL and our Services.

Hello Matthew,

In the proposed way it does not work. In Zabbix a host name must be unique. What you call db_label is the Zabbix hostname.

If you need some more information about FromDual here are some resources:

Hello Wills,

No problem. I am lucky we finally found it. Any improvement suggestions are welcome!

Hello Wills,

First I would check if the host ‘util-mysql0’ matches EXACTLY the hostname in Zabbix server. That is the typical problem. Are you sure this specific item (FromDual.MySQL.mysql.version) exists under this host?

Hello Wills,

What about uploading data of some of the relevant modules (mysql or innodb for example)? Have you changed something except upgrading the mpm agent?

Hi Wills,

This is OK because the key does not exist in any template.

https://github.com/ioggstream/ndb_size.pl/tree/add_ondisk

Hello Cédric,

OK. I see. 5.1 is a bit outdated now… Most of our customers are going to 5.5 now or are already on it. So we have to focus on the future.

Hello Cédric,

What the monitor does is the following:

SELECT SUM(compress_time) AS compress_time, SUM(uncompress_time) AS uncompress_time
  FROM information_schema.INNODB_CMP

The MySQL documentation states in chapter The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables:

zabbix_sender was capable to connect and send (sent: 1) but processing the item failed (Processed 0, Failed 1)

Hello

I have successfully installed and configured zabbix to work with your performance monitoring. However, every once in a while, the graphs in zabbix do not display any information. It seems when I invoke FromDualMySQLagent.pl things go back to normal. Do I need to setup a cron to refresh the data?

Hello William,

A cron job should not be necessary. It looks like the Zabbix Server disables this specific Zabbix agent/host for some reasons. So we should find, why! Could you please have a look at the zabbix_server.log and the zabbix_agent.log and let us know if you find anything?

Hi handon,

In the MPM installation guide I can find this:

Hello amatus,

Not sure if I understood you correctly. But the output is in the following Before and After code boxes…