Go高并发数据库操作的bug——max_prepared_stmt_count

高并发情况下MySQL操作报错

Can't create more than max_prepared_stmt_count statements (current value: 16382)

这是mysql的preparedStatement使用超限问题

mysql> show global status like 'com_stmt%';
+-------------------------+--------+
| Variable_name           | Value  |
+-------------------------+--------+
| Com_stmt_execute        | 117814 |
| Com_stmt_close          | 104421 |
| Com_stmt_fetch          | 0      |
| Com_stmt_prepare        | 126965 |
| Com_stmt_reset          | 0      |
| Com_stmt_send_long_data | 0      |
| Com_stmt_reprepare      | 0      |
+-------------------------+--------+
7 rows in set (0.00 sec)

待解决~