Changes between Version 30 and Version 31 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
09/06/10 09:00:20 (11 years ago)
Author:
Dan Zubey
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v30 v31  
    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]
    80 {{
     79Can view the list of expensive queries by editing /etc/mysql/my.cnf and uncommenting/adding:
     80{{{
    8181log_slow_queries        = /var/log/mysql/mysql-slow.log
    8282long_query_time = 2
    83 }}
     83}}}
    8484and restart mysql.
    8585
    86 This will log queries that take longer than 2 seconds to run. View with [BR]
     86This will log queries that take longer than 2 seconds to run. View with:
    8787
    88 {{
     88{{{
    8989tail -f /var/log/mysql/mysql-slow.log
    90 }}
     90}}}
    9191
    9292----
    93 By installing 'mytop', you can see real-time status on the database [BR]
     93By installing 'mytop', you can see real-time status on the database:
    9494 
    95 {{
     95{{{
    9696sudo apt-get install mytop
    9797mytop -uUSERNAME -pPASSWORD
    98 }}
     98}}}
    9999
    100100type 'o' to force the longest-running queries to the top of the screen.