mysql-query_retries_on_failure?

[aaron.i...@gmail.com]

Hi René,

I cannot seem to find specific documentation on the use of the mysql-query_retries_on_failure global variable.

The only mention of it, that I've found in the documentation is here and it under reference to mysql_query_rules.

retries - the maximum number of times a query needs to be re-executed in case of detected failure during the execution of the query. If retries is not specified, global variable mysql-query_retries_on_failure applies

Is this the default retries of a failed query if no query rules are in place or does it only apply to query rules?

Thanks,

Aaron

 

[René Cannaò]

Hi Aaron,

I took a note to improve the documentation on this matter.

At https://github.com/sysown/proxysql/blob/v1.3.0e/lib/MySQL_Session.cpp#L1501 , the default retries for any query is set from mysql-query_retries_on_failure . But if Query Processor has set "retries" in one of the query rules for that specific query, the value of "mysql_query_rules.retries applies ( https://github.com/sysown/proxysql/blob/v1.3.0e/lib/MySQL_Session.cpp#L1505 ) .

Thanks

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[aaron.i...@gmail.com]

Hi René,

Thank you for the clarification.

Along the same lines, what does mysql-query_processor_iterations do?

Thanks,

Aaron

To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.

[René Cannaò]

Hi Aaron,

ok, another note to myself to update documentation :D
It is described here:
https://github.com/sysown/proxysql/blob/master/doc/release_notes/ProxySQL_v1.2.2.md
https://www.percona.com/blog/2016/08/30/mysql-sharding-with-proxysql/

The problem is that the current implementation of ProxySQL doesn't support Global Replace in regex . So a workaround to this was, from release note:
if mysql_query_rules.flagOUT is set and mysql-query_processor_iterations is greater than 0, a matching rule will set flagIN and starts processing rules from the beginning up to mysql-query_processor_iterations iterations

Therefore, mysql-query_processor_iterations allows to jump back in mysql_query_rules.

Note: Global Replace in regex will be introduced very soon, as I am working on it right now.

To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+unsubscribe@googlegroups.com.

[aaron.i...@gmail.com]

Great, thanks René.  Keep up the great work.

Aaron

[René Cannaò]

Thanks! :)

To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+unsubscribe@googlegroups.com.