MySQL Forums
Forum List  »  Performance

Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW
Posted by: xiaobin lin
Date: February 17, 2014 05:20AM

As in the code
"
void update_server_status()
{
ulonglong end_utime_of_query= current_utime();
if (end_utime_of_query > utime_after_lock + variables.long_query_time)
server_status|= SERVER_QUERY_WAS_SLOW;
}
"

This means that when deciding whether the query is a slow_query, the lock time is excluded.

Is it reasonable?
Will it be better to use start_utime to instead utime_after_lock here?

Options: ReplyQuote


Subject
Views
Written By
Posted
Is it reasonable that lock_time is not included when decide SERVER_QUERY_WAS_SLOW
1742
February 17, 2014 05:20AM


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.