How to filter MySQL slow queries using pt-query-digest
Kedar
The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
Browsing Tag
Database
4 posts
Java termwork connect Access Database and operations
Prologue: Long back there were golden days of post graduation in the “great” DDIT (Now Dharamsinh Desai University), Nadiad. Assignments, termwork and journals or everything similar was in demand –…
Steps to Move Copy Rename MySQL Database
Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux…
In the world of NoSQL-Hands on Mongodb-1
I’m hearing a lot of “NoSQL” these days. To really understand how (and) does it works, I decided to give a try on MongoDB. MongoDB (hu*mongo*us) is an open source,…