Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +------------------------------------------------------------------------------+
- | argument |
- +------------------------------------------------------------------------------+
- | SET GLOBAL general_log = 'ON' |
- | SELECT * FROM TABLEB WHERE val = 1 LIMIT 0, 1000 |
- | SHOW INDEX FROM 'DB1'.'TABLEB' |
- | DELETE FROM TABLEC WHERE val = 1 |
- | UPDATE TABLEC SET val2 = 5 where val = 8 |
- | DELETE FROM TABLEA WHERE val = 1 |
- | DELETE FROM TABLED WHERE val = 1 |
- | SELECT COUNT(*) FROM TABLED WHERE val = 1 LIMIT 0, 1000 |
- | DELETE FROM TABLEB WHERE val = 1 |
- | SELECT COUNT(*) FROM TABLEB LIMIT 0, 1000 |
- | UPDATE TABLEB SET city = 'NYC' WHERE val IN (2,6) |
- | SELECT name FROM TABLEA WHERE val IN (2,3) LIMIT 0, 1000 |
- | SHOW INDEX FROM ''DB1.'TABLEA' |
- | INSERT INTO TABLEB VALUES(34) |
- | INSERT INTO TABLEA VALUES(34) |
- | INSERT INTO TABLEA VALUES(34) |
- | COMMIT |
- | SET GLOBAL general_log = 'OFF' |
- +------------------------------------------------------------------------------+
- |TABLE NAME| COUNTS
- | TABLEA | 5
- | TABLEB | 5
- | TABLEC | 2
- | TABLED | 1
- SELECT argument, COUNT (*) FROM mysql.general_log
- WHERE argument LIKE '%TABLEA%' OR
- argument LIKE '%TABLEB%' OR
- argument LIKE '%TABLEC%' OR
- argument LIKE '%TABLED%'
- GROUP BY argument ORDER BY TIMES ASC;
Add Comment
Please, Sign In to add comment