search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.06k stars 983 forks source link

`SELECT CONFIG INTO OUTFILE` is missing fast query rules data #4445

Open skorupeck opened 9 months ago

skorupeck commented 9 months ago

It seems that (at least on ProxySQL 2.5.3) following command:

SELECT CONFIG INTO OUTFILE path_to_file;

is not dumping the contents of mysql_query_rules_fast_routing (only mysql_query_rules are included).

renecannao commented 9 months ago

Hi @skorupeck . This is correct, SELECT CONFIG INTO OUTFILE doesn't save mysql_query_rules_fast_routing . This is consistent with the fact that mysql_query_rules_fast_routing cannot be loaded from configuration file.

skorupeck commented 9 months ago

I see, thank you. Is there any specific technical reason for this? Or you maybe plan to fix/change it in the future?