Friday, April 11, 2014

MySql: How to check status

run below query:

mysqladmin -u root -p status

Know slow queries..

enable below lines in /etc/mysql/my.conf

log-slow-queries
long_query_time = 1

No comments:

Post a Comment