Changes between Version 27 and Version 28 of InstallationGuidelines/MySQL

Timestamp:

09/06/10 08:55:56 (14 years ago)

Author:

Dan Zubey

Comment:

--

InstallationGuidelines/MySQL

@@ -62 +62 @@
 }}}
 
-Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns, however most of the time this field is unique & so indexed automatically]:
+Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns]:
  * gis_location.name
  * pr_person.first_name
@@ -75 +75 @@
 }}}
 
-These should already be done automatically in {{{models/zzz_1st_run.py}}}
+@ToDo: Add these to {{{models/zzz_1st_run.py}}}
 == Troubleshooting ==
-Can view the list of expensive queries using: ''tbc''
+Can view the list of expensive queries by editing ''/etc/mysql/my.cnf'' and uncommenting/adding
+{{
+log_slow_queries        = /var/log/mysql/mysql-slow.log
+long_query_time = 2
+}}
+and restart mysql.
 
+This will log queries that take longer than 2 seconds to run. View with:
+
+{{tail -f /var/log/mysql/mysql-slow.log}}
+
+----
+By installing 'mytop', you can see real-time status on the database
+ 
+{{sudo apt-get install mytop
+mytop -uUSERNAME -pPASSWORD}}
+
+type 'o' to force the longest-running queries to the top of the screen.
+----
 == Replication ==
 In order to have a backup instance, configure replication from the Master node to a Backup node: