Changes between Version 6 and Version 7 of PS1_IPP_Czarlog_20150316

Timestamp:

Mar 17, 2015, 5:30:26 PM (11 years ago)

Author:

eugene

Comment:

--

PS1_IPP_Czarlog_20150316

@@ -12 +12 @@
  * 06:00 EAM: stdscience running a bit slow, restarting; also restarting pv3diff
  * 10:21 Bill: disabled  ipp-misc site on ippc17 which is where the getsmf script lives. It requires nebulous.
+ * 17:20 EAM: Bill upgraded the ippdb00 mysql to 5.6 today.  things restarted fine and seemed to run ok for a while.  around 16:15, Bill reported errors going to the log.  looking into these, I concluded we were having trouble with locks due to the innodb adaptive index hash (see http://dev.mysql.com/doc/refman/5.6/en/innodb-adaptive-hash.html).  I turned of adaptive hash with the following:
+{{{
+mysql> set global innodb_adaptive_hash_index = 0;
+}}}
+So far, it looks like this is helping (we are not getting a build up of long thread waits in the SEMAPHORES section of show engine innodb status\G)
 
 === Wednesday : 2015.03.18 ===