Hi guys, could someone take a look at MDEV-6817?
i'm testing a stress test with aria and row_format=page
the problem is, running many
php>while(1){
mysql>select max(column) from table;
php> get the value, sum+1
mysql>insert into table (the value of column+1)
php>}
i got some problems...
the value of the first max(column) sometimes return an old value
in others words, the query isn't consistent, or the table invalidation
code is wrong
i got a value 296 at query cache
if i change the autocommit from 1 to 0, i got a value of 297, i could
use SQL_NO_CACHE and got the same 297 value
the problem only occur with row_format=page
--
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
