/data1/6.0.9/6.0.9-x86_64/bin/mysqld, Version: 6.0.9-alpha-log (MySQL Community Server (GPL)). started with: Tcp port: 19306 Unix socket: /data1/6.0.9/6.0.9-x86_64/mysql-test/var/tmp/master.sock Time Id Command Argument 090222 18:52:51 1 Connect root@localhost on 090222 18:52:52 1 Query select @@version_comment limit 1 1 Query SELECT DATABASE() 1 Init DB test 1 Query DROP TABLE IF EXISTS table10_innodb_int_autoinc 1 Query CREATE TABLE `table10_innodb_int_autoinc` (pk integer auto_increment, `int` int, primary key (pk)) ENGINE=innodb 1 Query 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') 1 Query create database omer 1 Query create table omer.zzlog (d datetime, rw int, od int, nw int) 1 Query 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`) 1 Query SET AUTOCOMMIT=OFF 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:53 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:54 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:55 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:56 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:57 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:58 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:52:59 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:53:00 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:53:01 1 Query START TRANSACTION 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`-10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query SET @randpk=FLOOR(0 + (RAND() * 10)) 1 Query UPDATE `table10_innodb_int_autoinc` SET `int`=`int`+10 WHERE pk=@randpk 1 Query insert into omer.zzlog values (now(), old.`pk`, old.`int`, new.`int`) 1 Query COMMIT 1 Query select sleep(1) 090222 18:53:02 1 Query select * from table10_innodb_int_autoinc 1 Query select avg(`int`) from table10_innodb_int_autoinc 1 Query select * from omer.zzlog 1 Query show create table test.table10_innodb_int_autoinc 1 Query drop database omer 1 Query drop table test.table10_innodb_int_autoinc 1 Quit