IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 92 and Version 93 of Moped_accident


Ignore:
Timestamp:
Jun 5, 2012, 3:05:29 PM (14 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Moped_accident

    v92 v93  
    170170 * '''ONGOING''' play binlogs taken from ippdb02 on ippdb00 (Started at 10:43; Complete at TODO)
    171171   * In order not to block processing I asked Gavin to leave the dns configuration so that nebulous.ipp.ifa.hawaii.edu points to ippdb02
    172    * 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...
    173    * 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...
     172   * 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.
     173   * 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.
     174   * Further ingestions executed with: {{{'mysqlbinlog <binlog> | grep -v 'COMMIT/*!*/' | grep -v BEGIN | mysql -u root -p nebulous'}}}.
    174175 * '''DONE''' compress all possible logs on ippdb00: I compressed the mysql slowlog. I didn't find the nebdiskd log though...
    175176 * ask gavin to change dns so that nebulous.ipp.ifa.hawaii.edu points to ippdb00 again