Changes between Version 29 and Version 30 of InstallationGuidelines/MySQL
- Timestamp:
- 09/06/10 08:57:58 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/MySQL
v29 v30 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]79 Can view the list of expensive queries by editing ''/etc/mysql/my.cnf'' and uncommenting/adding [BR] 80 80 {{ 81 81 log_slow_queries = /var/log/mysql/mysql-slow.log … … 86 86 This will log queries that take longer than 2 seconds to run. View with [BR] 87 87 88 {{tail -f /var/log/mysql/mysql-slow.log}} 88 {{ 89 tail -f /var/log/mysql/mysql-slow.log 90 }} 89 91 90 92 ---- 91 93 By installing 'mytop', you can see real-time status on the database [BR] 92 94 93 {{sudo apt-get install mytop 94 mytop -uUSERNAME -pPASSWORD}} 95 {{ 96 sudo apt-get install mytop 97 mytop -uUSERNAME -pPASSWORD 98 }} 95 99 96 100 type 'o' to force the longest-running queries to the top of the screen.
