What to do with high database utilization? What if the database utilization is low but queries are slow?

With high database utilization:

• Check which queries consume resources (CPU, memory).
• Optimize heavy queries, add indexes.
• Consider scaling: replication, sharding.
• Configure connection pool to avoid excessive connections.
• Check background tasks and triggers that may load the database.

With low database utilization but slow queries:

• Analyze execution plans (EXPLAIN), look for inefficient operations.
• Check for missing necessary indexes.
• Assess whether queries are blocked by other transactions.
• Check database configuration parameters affecting caching and optimization.
• Consider rewriting queries for increased efficiency.

In both cases, it is important to use profiling and database monitoring to accurately identify causes and subsequent optimization.