@@ -, +, @@ "show processlist;" to list all the running mysql processes. "-- saved_sql.id=123" in the process info field. --- C4/Reports/Guided.pm | 1 + 1 file changed, 1 insertion(+) --- a/C4/Reports/Guided.pm +++ a/C4/Reports/Guided.pm @@ -593,6 +593,7 @@ sub execute_query { $dbh->do( 'UPDATE saved_sql SET last_run = NOW() WHERE id = ?', undef, $report_id ) if $report_id; + $sql = "-- saved_sql.id=$report_id\n" . $sql; my $sth = $dbh->prepare($sql); eval { $sth->execute(@$sql_params, $offset, $limit); --