technokid/my.cnf

Created May 7, 2020 12:21

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/technokid/76c74299c1b8360c8655b372f5ae959a.js"></script>
Save technokid/76c74299c1b8360c8655b372f5ae959a to your computer and use it in GitHub Desktop.

Download ZIP

Enable logger slow query in mysql

Raw

my.cnf

	slow_query_log = 1
	slow_query_log_file = /var/log/mysql/mysql-slow.log
	long_query_time = 1
	log_queries_not_using_indexes

	#then restart mysql server

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment