Home > Developers > Wiki > Direct To Database
Views


Due to missing/broken functionality in Mifos 1.x, current Mifos deployments often find it necessary to interact directly with the Mifos MySQL database. This document is an attempt to understand these interactions, mainly as discovery for how much engineering overhead would be incurred with database maintenance in a hosted/SaaS Mifos offering.

1   Catalog

Please add new recurring or one-time database interactions as 3rd-level headings.

1.1   Recurring

1.1.1   Sleeper Killer

Deployment:
Grameen Koota
Development cost:
1 person day (not recurring)
Used how often:
?

Naganand noticed that periodically killing MySQL threads that had been sleeping for long periods of time would increase performance(?) . The sleeper killer script was created for this purpose.

1.2   One-Time

1.2.1   Fix duplicate login names

Deployment:
Grameen Koota
Development cost:
?

Description in script comments.


Grameen logo