Bug #25785 set timestamp get 5 seconds to return
Submitted: 23 Jan 2007 15:15 Modified: 29 Mar 2011 18:52
Reporter: Roberto Spadim (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.11 and higher OS:Linux (linux)
Assigned to: CPU Architecture:Any
Tags: set timestamp

[23 Jan 2007 15:15] Roberto Spadim
hello i got some results from my slow query log see:

# administrator command: Init DB;
# Time: 070115 19:59:47
# User@Host: rdm[rdm] @ localhost []
# Query_time: 8  Lock_time: 0 Rows_sent: 0  Rows_examined: 0
SET timestamp=1168901987;
# administrator command: Ping;
# Time: 070115 20:01:59
# User@Host: rdm[rdm] @ localhost []
# Query_time: 5  Lock_time: 0 Rows_sent: 0  Rows_examined: 0
SET timestamp=1168902119;
# administrator command: Ping;
/usr/sbin/mysqld, Version: 5.1.14-beta-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.BL.sock
Time                 Id Command    Argument

How to repeat:
set timestamp with a no timestamp value

Suggested fix:
i donĀ“t know why it get 5 and 8 seconds sometimes
[26 Jan 2007 10:03] Hartmut Holzgraefe
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.
[29 Mar 2011 18:52] Roberto Spadim
not a problem with mysql 5.5 now