Changes between Version 91 and Version 92 of Moped_accident

Timestamp:

Jun 5, 2012, 3:02:36 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Moped_accident

@@ -170 +170 @@
  * '''ONGOING''' play binlogs taken from ippdb02 on ippdb00 (Started at 10:43; Complete at TODO)
    * In order not to block processing I asked Gavin to leave the dns configuration so that nebulous.ipp.ifa.hawaii.edu points to ippdb02
-   * For the first binlog I executed: {{{'mysqlbinlog <binlog> | mysql -u root -p nebulous'}}} which took 3 hours: "blocked" by COMMIT statements happening every other line or so...
-   * For the second binlog I executed: {{{'mysqlbinlog <binlog> | grep -v 'COMMIT/*!*/' | mysql -u root -p nebulous'}}}. That took TODO hours: "blocked" by BEGIN statements...
+   * For the first binlog I executed: {{{'mysqlbinlog <binlog> | mysql -u root -p nebulous'}}} which took 3 hours: slowed down by COMMIT statements happening every other line or so...
+   * For the second binlog I executed: {{{'mysqlbinlog <binlog> | grep -v 'COMMIT/*!*/' | mysql -u root -p nebulous'}}}. That took 75 minutes: slowed down by BEGIN statements...
  * '''DONE''' compress all possible logs on ippdb00: I compressed the mysql slowlog. I didn't find the nebdiskd log though...
  * ask gavin to change dns so that nebulous.ipp.ifa.hawaii.edu points to ippdb00 again