Changes between Version 33 and Version 34 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
09/06/10 09:59:17 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v33 v34  
    6262}}}
    6363
    64 Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns]:
     64Index 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]:
    6565 * gis_location.name
    6666 * pr_person.first_name
     
    6969
    7070{{{
    71 ALTER TABLE `gis_location` ADD INDEX ( `name` );
    72 ALTER TABLE `pr_person` ADD INDEX ( `first_name` );
    73 ALTER TABLE `pr_person` ADD INDEX ( `middle_name` );
    74 ALTER TABLE `pr_person` ADD INDEX ( `last_name` );
     71CREATE INDEX name__idx on gis_location(name);
     72CREATE INDEX first_name__idx on gis_location(first_name);
     73CREATE INDEX middle_name__idx on gis_location(middle_name);
     74CREATE INDEX last_name__idx on gis_location(last_name);
    7575}}}
    7676
    77 @ToDo: Add these to {{{models/zzz_1st_run.py}}}
     77These should already be done automatically by {{{models/zzz_1st_run.py}}}
    7878== Troubleshooting ==
    7979Can view the list of expensive queries by editing /etc/mysql/my.cnf and uncommenting/adding: