Skip to content

Instantly share code, notes, and snippets.

@jvadillo
Created December 20, 2017 08:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jvadillo/88d42e1d488d0bfc0e78621b239adfba to your computer and use it in GitHub Desktop.
Save jvadillo/88d42e1d488d0bfc0e78621b239adfba to your computer and use it in GitHub Desktop.
Activate logs in Xampp-Mysql
# The MySQL server
[mysqld]
#Enable Slow Query Log
long_query_time = 1
slow_query_log_file = "C:/slowquery.log"
#Do NOT Start Logging on Startup
slow_query_log = 1
general_log_file = "C:/xampp/genquery.log"
#Do NOT Start Logging on Startup
general_log = 1
#In phpMyAdmin, I went to the SQL tab, and ran this:
#SET GLOBAL general_log = 'ON';
#SET GLOBAL slow_query_log = 'ON';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment