# This test doesn't work with the embedded version as this code # assumes that one query is running while we are doing queries on # a second connection. # This would work if mysqltest run would be threaded and handle each # connection in a separate thread. # --source include/not_embedded.inc # PS causes different statistics --disable_ps_protocol connect (con1,localhost,root,,); connect (con2,localhost,root,,); flush status; show status like 'Table_lock%'; connection con1; SET SQL_LOG_BIN=0; --disable_warnings drop table if exists t1; --enable_warnings create table t1(n int) engine=myisam; insert into t1 values(1); connection con2; lock tables t1 read; unlock tables; lock tables t1 read; connection con1; --send update t1 set n = 3; connection con2; sleep 0.5; unlock tables; connection con1; reap; show status like 'Table_lock%'; drop table t1; # End of 4.1 tests # # lost_query_cost # select 1; show status like 'last_query_cost';