[Toolserver-l] excessively long query notifications

[River Tarnell]

hello,

if you run a MySQL query which takes longer than 600 seconds (10
minutes) to execute, you will now receive a warning message
("long-running query notification").  this message will be written to
your terminal, or if you aren't logged in, mailed to you.

if you receive one of these notifications, please consider fixing the
query, since it's using a lot of resources.

if the query can't be made any faster, you can suppress the
notification by writing /* SLOW_OK */ somewhere in the query, e.g.:

	SELECT /* SLOW_OK */ COUNT(*) from page;

but this won't work with the command-line MySQL client, because it
strips comments before executing the query.

	- river.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20070529/3ac59ae4/attachment.pgp