diff options
| author | Staale Smedseng <staale.smedseng@sun.com> | 2010-05-12 13:19:12 +0200 |
|---|---|---|
| committer | Staale Smedseng <staale.smedseng@sun.com> | 2010-05-12 13:19:12 +0200 |
| commit | 44fe4c707b3aaa923d414efd801462658d800c1d (patch) | |
| tree | 4ef21dd129bfee355e60f5dc81af3bbf22b119f1 /sql/sql_update.cc | |
| parent | b0b0000d4069d055cdbe9c5c7f2fd59eb31cc529 (diff) | |
| download | mariadb-git-44fe4c707b3aaa923d414efd801462658d800c1d.tar.gz | |
Bug #49756 Rows_examined is always 0 in the slow query log for
update statements
Only SELECT statements report any examined rows in the slow
log. Slow UPDATE, DELETE and INSERT statements report 0 rows
examined, unless the statement has a condition including a
SELECT substatement.
This patch adds counting of examined rows for the UPDATE and
DELETE statements. An INSERT ... VALUES statement will still
not report any rows as examined.
Diffstat (limited to 'sql/sql_update.cc')
| -rw-r--r-- | sql/sql_update.cc | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/sql_update.cc b/sql/sql_update.cc index d8141deba63..69f3a29e923 100644 --- a/sql/sql_update.cc +++ b/sql/sql_update.cc @@ -425,6 +425,7 @@ int mysql_update(THD *thd, { goto err; } + thd->examined_row_count+= examined_rows; /* Filesort has already found and selected the rows we want to update, so we don't need the where clause @@ -471,6 +472,7 @@ int mysql_update(THD *thd, while (!(error=info.read_record(&info)) && !thd->killed) { + thd->examined_row_count++; if (!(select && select->skip_record())) { if (table->file->was_semi_consistent_read()) @@ -577,6 +579,7 @@ int mysql_update(THD *thd, while (!(error=info.read_record(&info)) && !thd->killed) { + thd->examined_row_count++; if (!(select && select->skip_record())) { if (table->file->was_semi_consistent_read()) |