Guest User

Untitled

a guest
May 26th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. +------------------------------------------------------------------------------+
  2. | argument |
  3. +------------------------------------------------------------------------------+
  4. | SET GLOBAL general_log = 'ON' |
  5. | SELECT * FROM TABLEB WHERE val = 1 LIMIT 0, 1000 |
  6. | SHOW INDEX FROM 'DB1'.'TABLEB' |
  7. | DELETE FROM TABLEC WHERE val = 1 |
  8. | UPDATE TABLEC SET val2 = 5 where val = 8 |
  9. | DELETE FROM TABLEA WHERE val = 1 |
  10. | DELETE FROM TABLED WHERE val = 1 |
  11. | SELECT COUNT(*) FROM TABLED WHERE val = 1 LIMIT 0, 1000 |
  12. | DELETE FROM TABLEB WHERE val = 1 |
  13. | SELECT COUNT(*) FROM TABLEB LIMIT 0, 1000 |
  14. | UPDATE TABLEB SET city = 'NYC' WHERE val IN (2,6) |
  15. | SELECT name FROM TABLEA WHERE val IN (2,3) LIMIT 0, 1000 |
  16. | SHOW INDEX FROM ''DB1.'TABLEA' |
  17. | INSERT INTO TABLEB VALUES(34) |
  18. | INSERT INTO TABLEA VALUES(34) |
  19. | INSERT INTO TABLEA VALUES(34) |
  20. | COMMIT |
  21. | SET GLOBAL general_log = 'OFF' |
  22. +------------------------------------------------------------------------------+
  23.  
  24. |TABLE NAME| COUNTS
  25. | TABLEA | 5
  26. | TABLEB | 5
  27. | TABLEC | 2
  28. | TABLED | 1
  29.  
  30. SELECT argument, COUNT (*) FROM mysql.general_log
  31. WHERE argument LIKE '%TABLEA%' OR
  32. argument LIKE '%TABLEB%' OR
  33. argument LIKE '%TABLEC%' OR
  34. argument LIKE '%TABLED%'
  35. GROUP BY argument ORDER BY TIMES ASC;
Add Comment
Please, Sign In to add comment