commit 3b3a6d78a63e93b43d3815f7e32a32458a82a3a9
author Jenkins <jenkins@review.openstack.org> Wed Jan 23 20:31:13 2013 +0000
committer Gerrit Code Review <review@openstack.org> Wed Jan 23 20:31:13 2013 +0000
tree 131beb29e70cfd6f55fffb05505653460393e9ca
parent 01f5b261b1891e4e5288fa9c4745d9ea19b14a9a
parent 767cd631796b5404e6331cee72977a1fcec68024

Merge "Set MySQL slow log to record every query"

lib/databases/mysql

diff --git a/lib/databases/mysql b/lib/databases/mysql
index 965df6e..9524253 100644
--- a/lib/databases/mysql
+++ b/lib/databases/mysql
@@ -68,10 +68,10 @@
     sudo sed -i -e "/^\[mysqld\]/ a \
 log-slow-queries = /var/log/mysql/mysql-slow.log" $MY_CONF
 
-    # Log any query taking longer than a second
+    # Log all queries (any query taking longer than 0 seconds)
     sudo sed -i '/long.query.time/d' $MY_CONF
     sudo sed -i -e "/^\[mysqld\]/ a \
-long-query-time = 1" $MY_CONF
+long-query-time = 0" $MY_CONF
 
     # Log all non-indexed queries
     sudo sed -i '/log.queries.not.using.indexes/d' $MY_CONF