how can i clear stats_mysql_prepared_statements_info？

[lddlww]

how can i delete rows of stats_mysql_prepared_statements_info table？

[renecannao]

Hi @lddlww .
Can you please formulate a bit further?
Considering that this table shows internal metadata, rows would go away only if proxysql forgets some of these metadata.
Why would you want that?

Thanks

[lddlww]

i use php execute prepare statement for test table named t1 and executed sql is select * from t1 where id=?,
then i add one column for t1 , after i do execute prepare statement again，it throws error PHP Warning: Packets out of order. Expected 1 received 15. Packet size=5, and i found proxysql.log print some logs, one of them is MySQL_PreparedStatement.cpp:386:update_metadata(): [WARNING] Updating metadata for stmt 145 , user prog_test, query SELECT * FROM t1 WHERE id =?

so i want to disable global stmt 145 , and then execute prepare statment to check if it still reports above error

[lddlww]

my proxysql version is 2.0.10

[renecannao]

This is a known and old bug.
Please upgrade

[lddlww]

@renecannao thank you, i will try it

[lddlww]

@renecannao i use ProxySQL version 2.3.2-10-g8cd66cf, codename Truls, it still reports error， and i switch port from 6033 to 3306，it always works normal

reproduced by：#2812

thank you