oli's blog

InnoDB Buffer Pool

The InnoDB Buffer Pool is the memory area where the InnoDB Storage Engine caches its data and index blocks. Each InnoDB data and index block has a size of Innodb_page_size (16384 byte = 16 kbyte). The InnoDB Buffer Pool is configured in bytes with the innodb_buffer_pool_size variable. On a dedicated system the InnoDB Buffer Pool can be configured up to 80% of the systems physical RAM (free).

A bug report for the following problem has been opened: http://support.fromdual.com/bugs/view.php?id=40

A customer asked:

I would like to know if the FromDual Performance Monitor for MySQL works with Zabbix 2.0?

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?