← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/innodb.test

  • Committer: Monty Taylor
  • Date: 2010-03-11 18:27:20 UTC
  • mfrom: (1333 staging)
  • mto: This revision was merged to the branch mainline in revision 1348.
  • Revision ID: mordred@inaugust.com-20100311182720-hd1h87y6cb1b1mp0
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/innodb.test
837
837
checksum table t1, t2, t3, t4;
838
838
checksum table t1, t2, t3, t4;
839
839
checksum table t1, t2, t3, t4;
840
 
#show table status;
 
840
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
841
841
drop table t1,t2,t3;
842
842
 
843
843
#
1028
1028
## Not deterministic.
1029
1029
# Test for testable InnoDB status variables. This test
1030
1030
# uses previous ones(pages_created, rows_deleted, ...).
1031
 
#show status like "Innodb_buffer_pool_pages_total";
1032
 
#show status like "Innodb_page_size";
1033
 
#show status like "Innodb_rows_deleted";
1034
 
#show status like "Innodb_rows_inserted";
1035
 
#show status like "Innodb_rows_updated";
 
1031
--replace_column 2 #
 
1032
show status like "Innodb_buffer_pool_pages_total";
 
1033
--replace_column 2 #
 
1034
show status like "Innodb_page_size";
 
1035
--replace_column 2 #
 
1036
show status like "Innodb_rows_deleted";
 
1037
--replace_column 2 #
 
1038
show status like "Innodb_rows_inserted";
 
1039
--replace_column 2 #
 
1040
show status like "Innodb_rows_updated";
1036
1041
 
1037
1042
## Test for row locks InnoDB status variables.
1038
 
#show status like "Innodb_row_lock_waits";
1039
 
#show status like "Innodb_row_lock_current_waits";
1040
 
#show status like "Innodb_row_lock_time";
1041
 
#show status like "Innodb_row_lock_time_max";
1042
 
#show status like "Innodb_row_lock_time_avg";
 
1043
--replace_column 2 #
 
1044
show status like "Innodb_row_lock_waits";
 
1045
--replace_column 2 #
 
1046
show status like "Innodb_row_lock_current_waits";
 
1047
--replace_column 2 #
 
1048
show status like "Innodb_row_lock_time";
 
1049
--replace_column 2 #
 
1050
show status like "Innodb_row_lock_time_max";
 
1051
--replace_column 2 #
 
1052
show status like "Innodb_row_lock_time_avg";
1043
1053
 
1044
1054
# Test for innodb_sync_spin_loops variable
1045
1055
show variables like "innodb_sync_spin_loops";