Changes between Version 28 and Version 29 of InstallationGuidelines/MySQL
- Timestamp:
- 09/06/10 08:56:59 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/MySQL
v28 v29 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 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 … … 84 84 and restart mysql. 85 85 86 This will log queries that take longer than 2 seconds to run. View with :86 This will log queries that take longer than 2 seconds to run. View with [BR] 87 87 88 88 {{tail -f /var/log/mysql/mysql-slow.log}} 89 89 90 90 ---- 91 By installing 'mytop', you can see real-time status on the database 91 By installing 'mytop', you can see real-time status on the database [BR] 92 92 93 93 {{sudo apt-get install mytop
