Skip to content

Instantly share code, notes, and snippets.

@lukmdo

lukmdo/MySQL DBA,DBD

Created July 28, 2010 16:12
Show Gist options
  • Save lukmdo/495068 to your computer and use it in GitHub Desktop.
Save lukmdo/495068 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL profiling
Raw
MySQL DBA,DBD
SELECT @@profiling;
SET profiling=1|0;
SHOW PROFILES;
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
SELECT @@global.time_zone, @@session.time_zone;
SET time_zone = '+00:00';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment