I am using multiple databases in my app for multi tenacy environment.
In my app user login with tenant id and connect to respective database.
The scenario is when 5 users connect to 5 databases and perform some activity in that case site performance going down and some time database server become unresponsive.
In each database we have same schema with different data regarding to users of that tenant.
I am using multi tenant system and doing performance testing of multi tenant application. In case of single tenant it is working fine but once I enable tenants, then some time database servers not responding. Any clue?
It is a bit tricky to tell without any relevant information (e.g schema description). But a likely culprit would be a missing index on the relevant 'tenant_id' type field in each table that you are using to distinguish the various tenant datasets.
