This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

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 27-Nov-2009 11:43 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: 1773

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