A hospital database that runs fast in month one can slow to a crawl by month six — not because of hardware failure, but because of table fragmentation, missing indexes, and queries that were never profiled under load.

Proactive maintenance tasks that protect SLA uptime

  • Index fragmentation audits — tables that receive heavy INSERT/UPDATE/DELETE operations fragment over time. Running OPTIMIZE TABLE or ANALYZE TABLE monthly reclaims performance without downtime.
  • Indexing high-query columns — patient_id, appointment_date, and status columns in OPD tables are queried millions of times. A composite index on these columns turns a 2-second query into a 20ms one.
  • Slow query logging — enabling MySQL's slow query log with a 1-second threshold captures queries that are candidates for optimisation before users notice the lag.
  • Connection pool management — unmanaged connections accumulate and exhaust the database server during peak OPD hours. A properly sized connection pool with timeout rules prevents this.
  • Scheduled maintenance windows — running VACUUM, REINDEX, or table optimization during low-traffic hours (late night) keeps performance consistent without impacting users.

Built into our support contracts

Kishuna Technology includes a quarterly database health review in all support contracts — catching performance drift before it becomes a patient-impacting outage.