Database Optimization

[surfrock66]

During the cleanup on INC #3 I realized how unoptimized my database was; you couldn't do queries or uploads while the cleanup was running, and each cleanup step took 40+ minutes. After optimizations, you CAN do parallel operations now, and each cleanup step is down to ~20 minutes. With cleanup running, the website load has gone from ~9 seconds to ~5 seconds. My steps need to be documented, and the table/db create scripts must be updated.

[surfrock66]

Scripts are updated. I recommend people run this:

ALTER TABLE torque.raw_logs ENGINE=InnoDB;
ALTER TABLE torque.torque_keys ENGINE=InnoDB;
ALTER TABLE torque.sessions ENGINE=InnoDB;