I just installed v1.2 of the module on Drupal 6.11 using Mysql 5.0.77 on FreeBSD 7.1 and php 5.2.9. I get the following error in the Drupal log seven times each time I run the report:
Details
Type php
Date Saturday, May 9, 2009 - 14:07
User admin
Location http://www.ageinplacetech.com/admin/reports/mysqlreport
Referrer http://www.ageinplacetech.com/admin/settings/mysqlreport
Message Division by zero in /usr/local/www/drupal6/sites/all/modules/mysqlreport/mysqlreport.module on line 593. (and on 580, 568, 574, 567, 561)
Severity error

The report still displays, in spite of these errors.

Comments

MMachnik’s picture

MMachnik commented

These are all related to InnoDB, I see. I am guessing you have no InnoDB databases and thus the value of those variables is 0. I do not get these, but I do have several InnoDB databases.

Of note, running mysqlreport from the shell, I was getting several errors that I tracked down to the removal of the status variable Innodb_buffer_pool_pages_latched from MySQL 5.0.77:

http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-77.html

Although I am running 5.0.77, this module does not give those errors, for what it is worth. The stats displayed are 0 as they should be.

However it may make sense for this module to remove the latch stats from 5.0.77+.

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Status: Active » Closed (cannot reproduce)

No answer in 2+ years, please feel free to reopen with new info