← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/r/innodb.result

  • Committer: Lee Bieber
  • Date: 2010-12-23 23:11:00 UTC
  • mfrom: (2024.1.1 clean)
  • Revision ID: kalebral@gmail.com-20101223231100-0rqirgz7ugkl10yp
Merge Brian - session list cleanup

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/tests/r/innodb.result
331
331
commit;
332
332
select * from t1;
333
333
id      val
334
 
commit;
335
334
drop table t1;
336
335
create table t1 (a integer) engine=innodb;
 
336
start transaction;
337
337
rename table t1 to t2;
338
338
create table t1 (b integer) engine=innodb;
339
 
start transaction;
340
339
insert into t1 values (1);
341
340
rollback;
342
341
drop table t1;
359
358
SELECT _userid FROM t1 WHERE _userid='marc@anyware.co.uk';
360
359
_userid
361
360
marc@anyware.co.uk
362
 
COMMIT;
363
361
drop table t1;
364
362
set autocommit=1;
365
363
CREATE TABLE t1 (
831
829
set autocommit=0;
832
830
create table t1 (a int not null) engine= innodb;
833
831
insert into t1 values(1),(2);
834
 
commit;
835
832
truncate table t1;
836
833
commit;
837
834
truncate table t1;
1429
1426
Variable_name   Value
1430
1427
show status like "Innodb_row_lock_time_avg";
1431
1428
Variable_name   Value
1432
 
set @my_innodb_sync_spin_loops = @@global.innodb_sync_spin_loops;
1433
1429
show variables like "innodb_sync_spin_loops";
1434
1430
Variable_name   Value
1435
1431
innodb_sync_spin_loops  30
1445
1441
show variables like "innodb_sync_spin_loops";
1446
1442
Variable_name   Value
1447
1443
innodb_sync_spin_loops  20
1448
 
set @@global.innodb_sync_spin_loops = @my_innodb_sync_spin_loops;
1449
 
set @my_innodb_thread_concurrency = @@global.innodb_thread_concurrency;
1450
1444
show variables like "innodb_thread_concurrency";
1451
1445
Variable_name   Value
1452
1446
innodb_thread_concurrency       0
1464
1458
show variables like "innodb_thread_concurrency";
1465
1459
Variable_name   Value
1466
1460
innodb_thread_concurrency       16
1467
 
set @@global.innodb_thread_concurrency = @my_innodb_thread_concurrency;
1468
1461
show variables like "innodb_concurrency_tickets";
1469
1462
Variable_name   Value
1470
1463
innodb_concurrency_tickets      500
2543
2536
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
2544
2537
insert into t1 select * from t2;
2545
2538
update t1 set b = (select e from t2 where a = d);
2546
 
commit;
2547
2539
create table t3(d int not null, e int, primary key(d)) engine=innodb
2548
2540
select * from t2;
2549
2541
commit;
2648
2640
CREATE TABLE t1 ( a int ) ENGINE=innodb;
2649
2641
BEGIN;
2650
2642
INSERT INTO t1 VALUES (1);
2651
 
COMMIT;
2652
2643
ALTER TABLE t1 ENGINE=innodb;
2653
2644
DROP TABLE t1;
2654
2645
CREATE TABLE t1 (id int PRIMARY KEY, f int NOT NULL, INDEX(f)) ENGINE=InnoDB;