High Number of Postgres Connections with Play + Slick

In this post, we will go through one of the recent interesting scenarios which we faced while debugging high number of postgres connections. Recently i started looking into pg_stat_activity to have a better understanding about the queries which were taking up a lot of time on postgres. For people thinking what is pg_stat_activity, it is … Continue reading High Number of Postgres Connections with Play + Slick

Best Practices for Creating Indexes in MySQL

MySQL is one of the most used databases in the current world. There has been a lot of research and thought gone into making the indexes in MySQL + InnoDB performant keeping the space complexity of these indexes in the same ballpark. In the context of this blog post, we will be going through the … Continue reading Best Practices for Creating Indexes in MySQL