ourdelta-developers team mailing list archive

[Cafuego <ubuntu@xxxxxxxxxxx>]

*** This bug is a duplicate of bug 356688 ***
    https://bugs.launchpad.net/bugs/356688

Did you explicitly turn statistics collection on? I had to on my
machines. In MySQL:

  SET GLOBAL userstat_running = 1

or in my.cnf:

  userstat_running = 1

Yes, the documentation is less than ideal currently ;-)

-- 
no statistics are generated
https://bugs.launchpad.net/bugs/357697
You received this bug notification because you are a member of OurDelta-
developers, which is the registrant for OurDelta.

Status in OurDelta - Builds for MySQL: Invalid

Bug description:
None of the Table/Index/User/Client statistics are generated after I upgraded my MySQL server. The current installed version is 5.0.77-d8-ourdelta54-log.

mysql> SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS;
Empty set (0.00 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.INDEX_STATISTICS;
Empty set (0.01 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.USER_STATISTICS;
Empty set (0.00 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.CLIENT_STATISTICS;
Empty set (0.00 sec)

Statistics worked before the upgrade, I think the version was 5.0.67 back then. The system is a Debian 5.0, kernel version 2.6.26-1-amd64.