No timestamps in general query log

[JT Justman]

Hello! We have a MySQL 5.1.61 server on Ubuntu 10.04. When we enable the general query log the timestamp column is blank. This is a production server with 400MB+ of logs generated per hour on about 60 databases with many thousands of InnoDB tables. There are no timestamps whatsoever. I set the logs by setting a variable, and the system has not been restarted. But I can't do so without a scheduled downtime.

On another server with same versions and nearly-identical config, the timestamp does show up.


Any ideas? Relevant variable output follows:

mysql> select @@log;
+-------+
| @@log |
+-------+
| 1 |
+-------+
1 row in set (0.00 sec)

mysql> select @@log_format;
ERROR 1193 (HY000): Unknown system variable 'log_format'
mysql> select @@general_log;
+---------------+
| @@general_log |
+---------------+
| 1 |
+---------------+
1 row in set (0.00 sec)

mysql> select @@general_log_file;
+--------------------------------+
| @@general_log_file |
+--------------------------------+
| /var/log/mysql/mysql-query.log |
+--------------------------------+
1 row in set (0.00 sec)

mysql> select @@log_output;
+--------------+
| @@log_output |
+--------------+
| FILE |
+--------------+
1 row in set (0.00 sec)