MarinShalamanov
commented
7 years ago - with "show global status like "com_stmt%";" you can observe the number of statements created and closed
- when I open an assignment and go to All submissions a lot of prepared statements are created. (20-60). empirically, it doesn't depend on the number of submissions
- usually we do:
stmt, err := db.Prepare("update submissions set verdict=?, reason=?, correct=?, total=?, points=? where id=?") if err != nil { log.Print(err) return err } defer stmt.Close()if there is an error (and the stmt is created it won't be closed). is that possible?
2016/10/25 20:58:54 Error 1461: Can't create more than max_prepared_stmt_count statements (current value: 16382)