I'm trying to understand possible reasons for high variance in time spent in MySQL Database in my web application. There are hours in which everything is smooth, and hours that are much slower. For example, this is a sample about time spent (the orange one is database time)
Other than the obvious
etc.. what can cause the database to become slow for a finite time frame?