MySQL Tipps

Slow Log im Betrieb einschalten

SHOW VARIABLES LIKE ‘slow_query_log%’;

SHOW VARIABLES LIKE ‘log_queries%’;

 

SET GLOBAL slow_query_log = ‘ON’;

SET GLOBAL slow_query_log_file = ‘/var/log/mysql/mysql-slow.log’;

SET GLOBAL log_queries_not_using_indexes = ‘ON’;

Slow Log im Betrieb wieder ausschalten

SET GLOBAL slow_query_log = ‘OFF’;

SET GLOBAL slow_query_log_file = ‘/var/log/mysql/mysql-slow.log’;

SET GLOBAL log_queries_not_using_indexes = ‘OFF’;

MySQL Aborted Clients anschauen und status löschen im laufenden Betrieb

show status like ‘Aborted_clients’;

flush status;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s