Changes between Version 30 and Version 31 of InstallationGuidelines/MySQL
- Timestamp:
- 09/06/10 09:00:20 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/MySQL
v30 v31 77 77 @ToDo: Add these to {{{models/zzz_1st_run.py}}} 78 78 == Troubleshooting == 79 Can view the list of expensive queries by editing ''/etc/mysql/my.cnf'' and uncommenting/adding [BR]80 {{ 79 Can view the list of expensive queries by editing /etc/mysql/my.cnf and uncommenting/adding: 80 {{{ 81 81 log_slow_queries = /var/log/mysql/mysql-slow.log 82 82 long_query_time = 2 83 }} 83 }}} 84 84 and restart mysql. 85 85 86 This will log queries that take longer than 2 seconds to run. View with [BR]86 This will log queries that take longer than 2 seconds to run. View with: 87 87 88 {{ 88 {{{ 89 89 tail -f /var/log/mysql/mysql-slow.log 90 }} 90 }}} 91 91 92 92 ---- 93 By installing 'mytop', you can see real-time status on the database [BR]93 By installing 'mytop', you can see real-time status on the database: 94 94 95 {{ 95 {{{ 96 96 sudo apt-get install mytop 97 97 mytop -uUSERNAME -pPASSWORD 98 }} 98 }}} 99 99 100 100 type 'o' to force the longest-running queries to the top of the screen.