[Deploying Sakai] database load

Charles Hedrick hedrick at rutgers.edu
Wed Dec 1 12:15:13 PST 2010

I've had a feeling that database load was heavier for 2.7 than 2.6. I finally put together a script to clarify it. If you look at https://sakai.rutgers.edu/stats/max.txt, you'll see for each day values 1, 6 and 11 for that day, when the values are sorted largest first. The numbers are CPU% on our database system. Our usage is going up slighly, but not enough to explain what looks like a factor of 2 increase. We can survive that, but we can't survive another increase like this.

Note that we changed not only from 2.6 to 2.7 but from Mysql 4.1 to 5.1. It's possible that it's mysql more than Sakai that is the issue. Our mysql is CPU limited. There's very little I/O.

More information about the production mailing list