Changes between Initial Version and Version 1 of Ticket #610, comment 53


Ignore:
Timestamp:
01/11/14 20:53:22 (3 years ago)
Author:
jim
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #610, comment 53

    initial v1  
    44So it's almost certainly the mysql {{{wait_timeout}}} value was far too low for big DB operations... A search of Trac shows [https://tech.transitionnetwork.org/trac/ticket/555#comment:68 Chris' work to optimise MySQL] was the cause.  
    55 
    6 I'd guess we scraped though before under the 2min limit because the ''throughput'' on the old disks was faster than ZFS, and the site DB was a good deal smaller than now. But wrangling a 1/4 TB database needs a good timeout set, or very fast disks. 
     6I'd guess we scraped though before under the 2min limit because the ''throughput'' on the old disks was faster than ZFS, and the site DB was a good deal smaller than now. But wrangling a 1/4GB database needs a good timeout set, or very fast disks. 
    77 
    88So this is now a 'minor' ticket that needs a little cleanups -- revert my php changes from a couple of comments back, and raise two new tickets with recommendations I've come to during this ticket...