Speeding Things Up
June 1st, 2010Maintenance on velospace is not always a flashy or exciting job. Problems are tough to track down and take a lot of digging, research, and trial and error fixes.
Tonight I found and fixed a problem that has vexed the site: crashes due to inadequate database resources. velospace runs on a MySQL database. As a popular site, velospace gets a lot of database traffic. Previously, MySQL was running out of open files to put and grab queries.
The fix, described here, here, and here doubled the number of files that the database can have open at any given time. The key was increasing the ‘ulimit -s [open files]‘ to 2048 from 1024. This should solve the recent downtime headaches and provide for a smoother experience.
- Greg