Enable MYSQL Slow Query Log#

  • Edit /etc/my.cnf
  • Add the following:
#Slow Query Log
#Log file
log-slow-queries = /var/log/slow-queries-log          

#Logs queries longer than 2 sec 
long_query_time = 2                                           

#Logs queries not using indexes
log-queries-not-using-indexes TRUE
  • Change owner on log file /var/log/slow-queries-log to
chown mysql.mysql
  • restart mysql
/etc/init.d/mysql restart

Back to mySQL

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-4) was last changed on 24-May-2017 15:30 by Hyve Support
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 3214

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1