Changes between Version 94 and Version 95 of Moped_accident

Timestamp:

Jun 6, 2012, 3:49:46 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Moped_accident

@@ -173 +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.
    * Further ingestions executed with: {{{'mysqlbinlog <binlog> | grep -v 'COMMIT/*!*/' | grep -v BEGIN | mysql -u root -p nebulous'}}}.
-   * Note: There are between 40 and 45 millions lines in each binlog when shown as text. There are roughly: SET statements: 7-8M; INSERT: 1.5-2.5M; DELETE: 0.2-0.5M; UPDATE: 1M; REPLACE: 0.1-0.3M)
+   * Note: There are between 40 and 45 millions lines in each binlog when shown as text. There are roughly: SET statements: 7-8M; INSERT: 1.5-2.5M; DELETE: 0.2-0.5M; UPDATE: 1M; REPLACE: 0.1-0.3M). The rest is either COMMIT, BEGIN or comments.
  * '''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