Changes between Version 27 and Version 28 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
09/06/10 08:55:56 (11 years ago)
Author:
Dan Zubey
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v27 v28  
    6262}}}
    6363
    64 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]:
     64Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns]:
    6565 * gis_location.name
    6666 * pr_person.first_name
     
    7575}}}
    7676
    77 These should already be done automatically in {{{models/zzz_1st_run.py}}}
     77@ToDo: Add these to {{{models/zzz_1st_run.py}}}
    7878== Troubleshooting ==
    79 Can view the list of expensive queries using: ''tbc''
     79Can view the list of expensive queries by editing ''/etc/mysql/my.cnf'' and uncommenting/adding
     80{{
     81log_slow_queries        = /var/log/mysql/mysql-slow.log
     82long_query_time = 2
     83}}
     84and restart mysql.
    8085
     86This will log queries that take longer than 2 seconds to run. View with:
     87
     88{{tail -f /var/log/mysql/mysql-slow.log}}
     89
     90----
     91By installing 'mytop', you can see real-time status on the database
     92 
     93{{sudo apt-get install mytop
     94mytop -uUSERNAME -pPASSWORD}}
     95
     96type 'o' to force the longest-running queries to the top of the screen.
     97----
    8198== Replication ==
    8299In order to have a backup instance, configure replication from the Master node to a Backup node: