MySQL [mysql]> select * from mysql.servers;
+-------------+-----------+----+----------+----------+-------+--------+---------+-------+
| Server_name | Host | Db | Username | Password | Port | Socket | Wrapper | Owner |
+-------------+-----------+----+----------+----------+-------+--------+---------+-------+
| SPIDER0 | 127.0.0.1 | | mysql | mysql | 25000 | | SPIDER | |
| SPT0 | 127.0.0.1 | | mysql | mysql | 20000 | | mysql | |
| SPT1 | 127.0.0.1 | | mysql | mysql | 20001 | | mysql | |
| TDBCTL0 | 127.0.0.1 | | mysql | mysql | 26000 | | TDBCTL | |
+-------------+-----------+----+----------+----------+-------+--------+---------+-------+
4 rows in set (0.000 sec)
MySQL [mysql]> tdbctl flush routing;
Query OK, 0 rows affected, 1 warning (0.001 sec)
MySQL [mysql]> show warnings;
+---------+-------+---------------------------------------+
| Level | Code | Message |
+---------+-------+---------------------------------------+
| Warning | 12028 | routing sql is null, flush do nothing |
+---------+-------+---------------------------------------+
1 row in set (0.000 sec)
MySQL [mysql]> select * from mysql.servers;
+-------------+-----------+----+----------+----------+-------+--------+---------+-------+
| Server_name | Host | Db | Username | Password | Port | Socket | Wrapper | Owner |
+-------------+-----------+----+----------+----------+-------+--------+---------+-------+
| SPIDER0 | 127.0.0.1 | | mysql | mysql | 25000 | | SPIDER | |
| SPT0 | 127.0.0.1 | | mysql | mysql | 20000 | | mysql | |
| SPT1 | 127.0.0.1 | | mysql | mysql | 20001 | | mysql | |
| TDBCTL0 | 127.0.0.1 | | mysql | mysql | 26000 | | TDBCTL | |
+-------------+-----------+----+----------+----------+-------+--------+---------+-------+
4 rows in set (0.000 sec)
MySQL [mysql]> tdbctl flush routing;
Query OK, 0 rows affected, 1 warning (0.001 sec)
MySQL [mysql]> show warnings;
+---------+-------+---------------------------------------+
| Level | Code | Message |
+---------+-------+---------------------------------------+
| Warning | 12028 | routing sql is null, flush do nothing |
+---------+-------+---------------------------------------+
1 row in set (0.000 sec)