Hi;
I'm getting that error when querying English Wikipedia. I add /* SLOW_OK */ to my queries. What is the sense of adding SLOW_OK if my queries are being killed anyway?
Regards, emijrp
Hi,
the email that you received should have a link to [1] that has the full explanation.
In short, if the replag is low, SLOW_OK queries will never be killed. If the replag is high, SLOW_OK queries will be killed, but they are allowed to run for a longer time than normal queries.
Petr Onderka [[User:Svick]]
[1]: https://wiki.toolserver.org/view/Database_access#Slow_queries_and_the_query_...
On Tue, Jan 31, 2012 at 21:10, emijrp emijrp@gmail.com wrote:
Hi;
I'm getting that error when querying English Wikipedia. I add /* SLOW_OK */ to my queries. What is the sense of adding SLOW_OK if my queries are being killed anyway?
Regards, emijrp
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
And why, instead kill them (that breaks the execution), aren't they put to the lowest CPU priority 0.00001% until replag is low?
2012/1/31 Petr Onderka gsvick@gmail.com
Hi,
the email that you received should have a link to [1] that has the full explanation.
In short, if the replag is low, SLOW_OK queries will never be killed. If the replag is high, SLOW_OK queries will be killed, but they are allowed to run for a longer time than normal queries.
Petr Onderka [[User:Svick]]
On Tue, Jan 31, 2012 at 21:10, emijrp emijrp@gmail.com wrote:
Hi;
I'm getting that error when querying English Wikipedia. I add /* SLOW_OK
*/
to my queries. What is the sense of adding SLOW_OK if my queries are
being
killed anyway?
Regards, emijrp
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
It's not a CPU issue. Some queries can prevent replag
On Tuesday, January 31, 2012, emijrp emijrp@gmail.com wrote:
And why, instead kill them (that breaks the execution), aren't they put
to the lowest CPU priority 0.00001% until replag is low?
2012/1/31 Petr Onderka gsvick@gmail.com
Hi,
the email that you received should have a link to [1] that has the full explanation.
In short, if the replag is low, SLOW_OK queries will never be killed. If the replag is high, SLOW_OK queries will be killed, but they are allowed to run for a longer time than normal queries.
Petr Onderka [[User:Svick]]
[1]:
https://wiki.toolserver.org/view/Database_access#Slow_queries_and_the_query_...
On Tue, Jan 31, 2012 at 21:10, emijrp emijrp@gmail.com wrote:
Hi;
I'm getting that error when querying English Wikipedia. I add /*
SLOW_OK */
to my queries. What is the sense of adding SLOW_OK if my queries are
being
killed anyway?
Regards, emijrp
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list:
It's not a CPU issue. Some queries can prevent replag
I understand, some queries could in theory prevent replag, but how queries users run on tables in their user databases could prevent replag if they cannot cause any locks on tables being replicated?
The only way is through intensive CPU or HDD or mem usage. Note that such queries are being killed for now.
My view is that query killer algorithms are to be revised. Replag is caused not necesserily by long running queries but by some special types of queries, which can work not that long.
mashiah
toolserver-l@lists.wikimedia.org