DBD-mysql
DBD-mysql copied to clipboard
MariaDB 10.3.9 Prepared statements leaking
trafficstars
After connection to the DB with mysql_server_prepare=1 every call to an INSERT statement via ->do method with placeholders increases Prepared_stmt_count on the DB.
for (1..10000)
{
$dbh->do("INSERT INTO aaa SET xxx=?", undef, 1)
}
Then
show global status like "%prepared%";
in the same session reveals some large number.
MariaBD 10.2.9 works well. Also no issue on MariaDB 10.3.9 with DBD::MariaDB driver.