https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29579
paxed <pasi.kalli...@koha-suomi.fi> changed:
What |Removed |Added
----------------------------------------------------------------------------
Assignee|koha-b...@lists.koha-commun |pasi.kalli...@koha-suomi.fi
|ity.org |
Status|NEW |Needs Signoff
--- Comment #1 from paxed <pasi.kalli...@koha-suomi.fi> ---
Created attachment 128037
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=128037&action=edit
Bug 29579: Show saved SQL report ID in database query
Bug 29579: Show saved SQL report ID in database query
When trying to figure out which saved SQL report caused too much load,
it's useful to have the report id show in the mysql process list.
This patch adds the saved SQL ID number as a comment line in front
of the SQL before passing it to the database.
To test:
1) Run a saved report that takes long enough time, so you can:
2) Connect to the database with your preferred client, and use
"show processlist;" to list all the running mysql processes.
3) The running saved SQL report should show up with
"-- saved_sql.id=123" in the process info field.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
