Project

General

Profile

« Previous | Next » 

Revision 13294

Added by Aaron Marcuse-Kubitza over 10 years ago

backups/mysql_snapshot: documented initial vegbiendev->jupiter upload time for GBIF/raw_occurrence_record.MYD (7 h for 91 GB = 3.7 MB/s)

View differences:

trunk/backups/mysql_snapshot
3 3 
.rel ../lib/sh/db.sh
4 4 

  		




  5
  5
  
    
main() { begin_target; mysql_snapshot "$@"; }


  		




  
  6
  
    

  		




  
  7
  
    
# initial upload time, vegbiendev->jupiter:


  		




  
  8
  
    
# GBIF/raw_occurrence_record.MYD: 91 GB/7 h ("08:59:07" - "02:00:02") = 3.7 MB/s


  		




  
  9
  
    
#     calculated using:


  		




  
  10
  
    
if false; then


  		




  
  11
  
    
ssh aaronmk@jupiter.nceas.ucsb.edu


  		




  
  12
  
    
stat --format=%z ~/Documents/BIEN/var/lib/mysql.bak/GBIF/rank.frm # start


  		




  
  13
  
    
stat --format=%z ~/Documents/BIEN/var/lib/mysql.bak/GBIF/raw_occurrence_record.MYD # end


  		




  
  14
  
    
fi


  		












Also available in:  Unified diff