92
92
Variable_name Value
93
93
Last_query_cost 4.805836
95
show status like 'com_show_status';
98
show status like 'hand%write%';
101
show status like '%tmp%';
103
Created_tmp_disk_tables 0
106
show status like 'hand%write%';
109
show status like '%tmp%';
111
Created_tmp_disk_tables 0
114
show status like 'com_show_status';
117
rnd_diff tmp_table_diff
119
SELECT VARIABLE_VALUE INTO @tc FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_connected';
120
SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_created' AND VARIABLE_VALUE < @tc;
122
SELECT VARIABLE_VALUE INTO @tr FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_running';
124
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_connected' AND VARIABLE_VALUE < @tc;
125
VARIABLE_NAME VARIABLE_VALUE
126
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_running' AND VARIABLE_VALUE < @tr;
127
VARIABLE_NAME VARIABLE_VALUE
added
removed
tests/r/status.result
