DBD-mysql icon indicating copy to clipboard operation
DBD-mysql copied to clipboard

MariaDB 10.3.9 Prepared statements leaking

Open yuriy-zhilovets2 opened this issue 6 years ago • 0 comments
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.

yuriy-zhilovets2 avatar Apr 04 '19 11:04 yuriy-zhilovets2