SummaryContents::
Reporting (26%) and Collection Sheet Processing (21%) produce the most load (47%) overall. On the busiest day (17th mar), Collection Sheet Processing (39%) and Reporting (23%) produced (62%) of the load.

The average response for the 17th was a second but ignoring a 10 min period (just before 1pm) reduces this to 0.75 second. This 10 min period was the 2nd worst in the data collected. The average response time was 31 seconds (for 1,765 transaction requests). It appears the system or mifos was shutdown for about 20 minutes after this.

The worst reponse time period was on 18th Mar between 22:50 and 22:56 (70 seconds).

In fact, there a number of spikes in server response time. Some look to be external to Mifos (backups?, propriety jobs?) and some look to be related to larger report runs.

Notes

Note: 8th March - 1st 12 hours data not available, 11th March - last 6 hours data not available

below is some number crunching of the transaction logs

Mifos Transactions

!GKLogAnalysisMarch8thTo24th.xls

And some images of the main charts if you can't see the charts in the above excel spreadsheet.

Load by Application Area

The mix of work seems to vary i.e. Wednesdays aren't all the same. However, some days very little collection sheet work happens (e.g Sun & Mon here).

!GKFunctionalAreaLoadMarch12thTo24th.xls

And some images of the main charts if you can't see the charts in the above excel spreadsheet.
csv-table:::widths: 40, 40

"", .. image:: FAL1803.gif .. image:: FAL1203.gif, .. image:: FAL1903.gif .. image:: FAL1303.gif, .. image:: FAL2003.gif .. image:: FAL1403.gif, .. image:: FAL2103.gif .. image:: FAL1503.gif, .. image:: FAL2203.gif .. image:: FAL1603.gif, .. image:: FAL2303.gif .. image:: FAL1703.gif, .. image:: FAL2403.gif

Static Resource Analysis

*Static resource web requests are 89% of total web requests. This figure remains constant each day regardless of how high or low the mifos transactions are.

Probably won't focus on static resources going forward except to see if the Mifos response header filter is having an effect - MaximisingBrowserCaching *

!MifosStaticResources.xls

This spreadsheet shows:

1. The Gb of static resource data served each day and how the patterns of Gb sent, requests and application Gb sent are pretty identical. There is almost twice as much static resource served than dynamic content.
2. The static resources in order of heaviness on the busiest day (17th March). The order doesn't vary by day much.
3. A break down of Http Status Codes for the 17.5 million static resource requests. There are surprisingly few '304's (<5%).

And some images if you can't see the charts in the above excel spreadsheet.

Load Your Own Data

Would put a zip of a mysqldump here (with 2.1M Mifos transactions) if I had someplace to upload it to.