- 论坛徽章:
- 0
|
原帖由 bigcat_eat_rat 于 2008-11-29 17:34 发表
每个慢查询语句前都有
#Time: 071226 18:06:48 这样的行,
这个是表示慢查询开始的时间还是mysqld将日志写入硬盘的起始时间?
因为现在要检查
就是你说的写日志到硬盘的i时间
见mysql源代码log.cc
- current_time=time(NULL);
- if (current_time != last_time)
- {
- last_time=current_time;
- struct tm tm_tmp;
- struct tm *start;
- localtime_r(¤t_time,&tm_tmp);
- start=&tm_tmp;
- sprintf(buff,"# Time: %02d%02d%02d %2d:%02d:%02d\n",
- start->tm_year % 100,
- start->tm_mon+1,
- start->tm_mday,
- start->tm_hour,
- start->tm_min,
- start->tm_sec);
- .......
- "# Query_time: %lu Lock_time: %lu Rows_sent: %lu Rows_examined: %lu\n",
- (ulong) (current_time - query_start_arg), //
- (ulong) (thd->time_after_lock - query_start_arg),
- (ulong) thd->sent_row_count,
- (ulong) thd->examined_row_count) == (uint) -1)
复制代码
query_start_arg为sql开始时间
current_time为写入日志时的时间 |
|