Changes between Version 29 and Version 30 of InstallationGuidelines/MySQL


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

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v29 v30  
    7777@ToDo: Add these to {{{models/zzz_1st_run.py}}}
    7878== Troubleshooting ==
    79 Can view the list of expensive queries by editing ''/etc/mysql/my.cnf'' and uncommenting/adding[BR]
     79Can view the list of expensive queries by editing ''/etc/mysql/my.cnf'' and uncommenting/adding [BR]
    8080{{
    8181log_slow_queries        = /var/log/mysql/mysql-slow.log
     
    8686This will log queries that take longer than 2 seconds to run. View with [BR]
    8787
    88 {{tail -f /var/log/mysql/mysql-slow.log}}
     88{{
     89tail -f /var/log/mysql/mysql-slow.log
     90}}
    8991
    9092----
    9193By installing 'mytop', you can see real-time status on the database [BR]
    9294 
    93 {{sudo apt-get install mytop
    94 mytop -uUSERNAME -pPASSWORD}}
     95{{
     96sudo apt-get install mytop
     97mytop -uUSERNAME -pPASSWORD
     98}}
    9599
    96100type 'o' to force the longest-running queries to the top of the screen.