Displaying 1 result from an estimated 1 matches for "com_stmt_prepare".
Did you mean:
com_stmt_reprepare
2012 Dec 13
0
max_prepared_stmt_count exceeded using RODBC + 64-bit win7
...the following may cast some
light:
show global status like 'com_stmt%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Com_stmt_close | 0 |
| Com_stmt_execute | 49931 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 36 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 36 |
| Com_stmt_send_long_data | 0 |
+-------------------------+-------+
If I understand right, the number of Com_stmt_close should be 'close to or
equal to' Com_stmt_execute, but is not. Rolling back...