Skip navigation links

MySQL Forums :: General :: No timestamps in general query log


Advanced Search

No timestamps in general query log
Posted by: JT Justman ()
Date: May 02, 2012 11:26AM

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)

Options: ReplyQuote


Subject Written By Posted
No timestamps in general query log JT Justman 05/02/2012 11:26AM
Re: No timestamps in general query log JT Justman 05/02/2012 05:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.