no statistics are generated

[jpjp]

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.

[Cafuego (cafuego)]

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 ;-)