Skip to content

Instantly share code, notes, and snippets.

@yugaego
Created January 28, 2017 12:29
Show Gist options
  • Save yugaego/2c60abbf254dac405207d9a5c4ed2bbf to your computer and use it in GitHub Desktop.
Save yugaego/2c60abbf254dac405207d9a5c4ed2bbf to your computer and use it in GitHub Desktop.
MySQL Slow Logs Query
SELECT query_time, rows_examined, sql_text, user_host 
FROM mysql.slow_log 
WHERE sql_text NOT LIKE "%INFORMATION_SCHEMA%" 
ORDER BY query_time DESC, rows_examined DESC 
LIMIT 0,25;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment