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";
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";
1044
1054
# Test for innodb_sync_spin_loops variable
1045
1055
show variables like "innodb_sync_spin_loops";