Re^2: Mysql query cache and DBI

So I tried setting the RowCacheSize => 1 to no avail, I'm still faced with the same issue. I'm not sure what step to take next.....

$dbh = DBI->connect($database,$self->{user},$self->{pass},{ RowCacheSi
+ze => 1}) or die DBI::errstr;
    $dbh->{AutoCommit}    = 0;
    $dbh->{RaiseError}    = 1;
[download]

Comment on Re^2: Mysql query cache and DBI Download Code

Replies are listed 'Best First'.
Re^3: Mysql query cache and DBI by josh803316 (Beadle) on Nov 07, 2009 at 21:00 UTC
It turns out the problem is related to transactions and AutoCommit......I had to do a $dbh->commit; after my reads (selects) in order to update the transactions. Once I added the commit after the select for my list_all it fixed the issue.	[reply]
Re^4: Mysql query cache and DBI by graff (Chancellor) on Nov 07, 2009 at 23:58 UTC
Ah. That's good to know. And of course, now that it's clear that RowCacheSize had nothing to do with the problem, you probably want to set it back to the default behavior.	[reply]
Re^4: Mysql query cache and DBI by reinaldo.gomes (Beadle) on Aug 14, 2018 at 06:28 UTC
Been banging my head against the wall for the last 24 hours, unable to find out why the heck Thread#2 wouldn't fetch whatever Thread#1 was inserting, even though I could fetch it from CLI or whatever, until I stumbled upon this post...	[reply]