Changes between Initial Version and Version 1 of Ticket #610, comment 53
- Timestamp:
- 01/11/14 20:53:22 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #610, comment 53
initial v1 4 4 So 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. 5 5 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.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/4GB database needs a good timeout set, or very fast disks. 7 7 8 8 So 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...