第二次的数据：




select group_name,wip_group ,count(1) from sfc.r107 where  rework_no='FFFBBB12899'
group by group_name,wip_group


select distinct special_route from sfc.r107 where  rework_no='FFFBBB12899'

select * from sfc.c_route_control_t where route_code in (360,478)  and state_flag=0 and group_next='TEST2'


SELECT * FROM ZJU.zj_sn_t

show global status like 'com_update%'

select (3120579541 -3120552173)/14.50   1887  select
select (200886149 -200885024)/22.67   49  insert
select (9664667 -9664624)/12.79   3.362  delete
select (139105588 -139105102)/14.59   33.31  update


show global status like 'Questions%'
show global status like 'Queries%'


select (2052361970 -2052343439)/14.01   1322.69  Questions
select (125716072948 -125715676658)/14.04  28225.7835  Questions

select count(1) from mysql.general_log  limit 1

select * from mysql.general_log



CALL SYANT.SESSION_START_6P('SMTLoading.exe', '1.0.1.5', 'C:\\SFIS_AMS\\SMTLoading.exe', '192.168.3.136', '94:C6:913:BC:68', 0, @RES); SELECT @RES AS '@RES'

set global general_log=0;
truncate table mysql.general_log ;

set global general_log=1;


然后用以下SQL统计出最多的SQL：
select * from (select argument, count(*) as number from mysql.general_log  group by argument)t
     order by number DESC;


select * from syant.z_session  where exe='SMTLoading.exe' and ip='192.168.3.136'
192.168.3.136

kill 53770644;
kill 54295063;
kill 54295308;
kill 54295334;
kill 54295355;
kill 54295927;
kill 54296036;
kill 54296669;