Untitled

Id  USER    Host    db  Command TIME    State   Info
10  sawa    ur*****l:47981  sawa    Query   34450   Waiting FOR TABLE   INSERT INTO DATA(DATA_VARIABLE_ID, DATA_TRANSDUCER_ID, DATA_NETWORK_ID,
11  sawa    ur*****l:47984  sawa    Query   34450   Waiting FOR TABLE   SELECT DISTINCT(RULE_POLICY_ID) FROM `RULESVIEW` WHERE VARIABLE_ID=14 AND POLICY_STATUS='active'
12  sawa    ur*****l:47987  sawa    Query   34479   Waiting FOR TABLE   SELECT DISTINCT NETWORK_NAME                                     FROM RULESVIEW
856 sawa    localhost   sawa    Query   75377   Sending DATA    SELECT\n\nv.*, d1.*\n\nFROM VARIABLES v\n\nJOIN DATA d1 ON (v.VARIABLE_ID = d1.DATA_VARIABLE_ID)\nLEFT OUTE
857 sawa    localhost   sawa    Query   75353   Sending DATA    SELECT\n\nv.*, d1.*\n\nFROM VARIABLES v\n\nJOIN DATA d1 ON (v.VARIABLE_ID = d1.DATA_VARIABLE_ID)\nLEFT OUTE
858 sawa    localhost   sawa    Query   75348   Sending DATA    SELECT\n\nv.*, d1.*\n\nFROM VARIABLES v\n\nJOIN DATA d1 ON (v.VARIABLE_ID = d1.DATA_VARIABLE_ID)\nLEFT OUTE
975 sawa    ur*****l:44559  sawa    Query   13874   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1013    sawa    ur*****l:43078  sawa    Query   14991   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '18'
1014    sawa    ur*****l:43081  sawa    Query   14976   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '6'
1015    sawa    ur*****l:43082  sawa    Query   14964   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1016    sawa    ur*****l:43083  sawa    Query   14955   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1017    sawa    ur*****l:43091  sawa    Query   14870   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1018    sawa    ur*****l:43092  sawa    Query   13862   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1019    sawa    ur*****l:43093  sawa    Query   12759   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1020    sawa    ur*****l:43094  sawa    Query   14841   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1021    sawa    ur*****l:43095  sawa    Query   14821   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1027    sawa    localhost   sawa    Query   14652   Waiting FOR TABLE   SELECT COUNT(*) FROM `sawa`.`VARIABLES`
1028    sawa    ur*****l:55190  sawa    Query   14464   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '38'
1029    sawa    ur*****l:55191  sawa    Query   14460   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1030    sawa    ur*****l:55192  sawa    Query   14459   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '18'
1058    sawa    ur*****l:43697  sawa    Query   13854   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1060    sawa    ur*****l:43705  sawa    Query   7027    Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1063    sawa    ur*****l:43711  sawa    Query   13711   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1065    sawa    ur*****l:43712  sawa    Query   13697   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '12'
1066    sawa    ur*****l:43716  sawa    Query   13692   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '12'
1102    sawa    ur*****l:42523  sawa    Query   12777   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '18'
1104    sawa    ur*****l:42530  sawa    Query   12722   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '15'
1105    sawa    ur*****l:42531  sawa    Query   12696   Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1111    sawa    localhost   sawa    Query   12418   Waiting FOR TABLE   SELECT COUNT(*) FROM `sawa`.`VARIABLES`
1118    sawa    ur*****l:52180  sawa    Query   8721    Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = '39'
1121    sawa    ur*****l:60407  sawa    Query   334 Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1124    sawa    ur*****l:35287  sawa    Query   354 Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1125    sawa    ur*****l:35288  sawa    Query   2554    Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1126    sawa    ur*****l:35296  sawa    Sleep   350     NULL
1164    sawa    localhost   sawa    Query   2209    Waiting FOR TABLE   SELECT COUNT(*) FROM `sawa`.`VARIABLES`
1171    sawa    localhost   sawa    Query   857 Waiting FOR TABLE   SELECT * FROM `VARIABLES`\n LIMIT 0, 30
1183    sawa    localhost   sawa    Query   857 Waiting FOR TABLE   SELECT COUNT(*) FROM `sawa`.`VARIABLES`
1197    sawa    ur*****l:34122  sawa    Sleep   348     NULL
1198    sawa    ur*****l:34123  sawa    Sleep   348     NULL
1199    sawa    ur*****l:34124  sawa    Query   344 Waiting FOR TABLE   SELECT *\nFROM (`VARIABLES`)\nWHERE `VARIABLE_TRANSDUCER_ID` = -1
1208    sawa    localhost   NULL    Query   0   NULL    SHOW PROCESSLIST