USE test;
DROP TABLE IF EXISTS table10_innodb_int_autoinc;
CREATE TABLE `table10_innodb_int_autoinc` (pk integer auto_increment, `int` int, primary key (pk)) ENGINE=innodb;
INSERT IGNORE INTO table10_innodb_int_autoinc VALUES  (NULL, '100') ,  (NULL, '100') ,  (NULL, '100') ,  (NULL, '100') ,  (NULL, '100') ,
                                                      (NULL, '100') ,  (NULL, '100') ,  (NULL, '100') ,  (NULL, '100') ,  (NULL, '100');
create database omer;
create table omer.zzlog (d datetime, rw int, od int, nw int);
create trigger log_updates after update on test.table10_innodb_int_autoinc for each row insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`);
SET AUTOCOMMIT=OFF;
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);
START TRANSACTION;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk;
   SET @randpk=FLOOR(0 + (RAND() * 10));
   UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk;
COMMIT;
select sleep(1);

select * from table10_innodb_int_autoinc;
select avg(`int`) from table10_innodb_int_autoinc;
select * from omer.zzlog;
show create table test.table10_innodb_int_autoinc;
drop database omer;
drop table test.table10_innodb_int_autoinc;