~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/t/innodb.test

  • Committer: kalebral at gmail
  • Date: 2010-12-04 02:13:38 UTC
  • mto: (1971.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1972.
  • Revision ID: kalebral@gmail.com-20101204021338-yek2zoraob5w7i5n
update files that did not have license or had incorrect license structure

Show diffs side-by-side

added added

removed removed

Lines of Context:
304
304
select * from t1;
305
305
update t1 set col2='7' where col1='4';
306
306
select * from t1;
307
 
ALTER TABLE t1 ADD co3 INT DEFAULT 42 NOT NULL;
 
307
alter table t1 add co3 int not null;
308
308
select * from t1;
309
309
update t1 set col2='9' where col1='2';
310
310
select * from t1;
1051
1051
show status like "Innodb_row_lock_time_avg";
1052
1052
 
1053
1053
# Test for innodb_sync_spin_loops variable
1054
 
set @my_innodb_sync_spin_loops = @@global.innodb_sync_spin_loops;
1055
1054
show variables like "innodb_sync_spin_loops";
1056
1055
set global innodb_sync_spin_loops=1000;
1057
1056
show variables like "innodb_sync_spin_loops";
1059
1058
show variables like "innodb_sync_spin_loops";
1060
1059
set global innodb_sync_spin_loops=20;
1061
1060
show variables like "innodb_sync_spin_loops";
1062
 
set @@global.innodb_sync_spin_loops = @my_innodb_sync_spin_loops;
1063
1061
 
1064
1062
# Test for innodb_thread_concurrency variable
1065
 
set @my_innodb_thread_concurrency = @@global.innodb_thread_concurrency;
1066
1063
show variables like "innodb_thread_concurrency";
1067
1064
set global innodb_thread_concurrency=1001;
1068
1065
show variables like "innodb_thread_concurrency";
1070
1067
show variables like "innodb_thread_concurrency";
1071
1068
set global innodb_thread_concurrency=16;
1072
1069
show variables like "innodb_thread_concurrency";
1073
 
set @@global.innodb_thread_concurrency = @my_innodb_thread_concurrency;
1074
1070
 
1075
1071
# Test for innodb_concurrency_tickets variable
1076
1072
show variables like "innodb_concurrency_tickets";