We think we found it….

The system slowdown was due, we think, to a database query not using an index to find the information it needed… After looking deeply into the MySQL manual we discovered we could have the database actually tell us which queries were running slowly. From that we can then tell the database (manually) to tell us…

System Slowdown

Some of you may have noticed (indeed, we’ve had at least one email saying someone had noticed :)) the system has been running slower in the evenings (US evening time). On one hand this is good news because it means the server is getting used a lot more, and by golly it is getting used…