Performance Tuning As our data grows in the database, it is always important to view database insights. We’ve been using some complex queries to solve difficult problems without checking how they affect the server performance. It’s always preferred to frequently visit the performance schema. USE performance_schema; Where to Begin With We want to boost cluster […]
Introduction Recently, we helped a large enterprise customer set up their data warehouse on Amazon Redshift using Azure AD for corporate credentials. This allowed users to log in with their corporate credentials, improving user experience and simplifying maintenance. We achieved this by setting up Azure AD federated access to Amazon Redshift. This post explains how […]
Introduction In this blog, we have mentioned how we can monitor the current operations of MongoDB instances with a small application developed by us. Its light weight application was developed using Nodejs, HTML, and javascript. It’s a very helpful application to monitor running queries on MongoDB and do the analysis on it: Pre-requisite : Nodejs […]
Introduction In the realm of MySQL databases, fragmentation can significantly impact performance and efficiency. This blog will delve into what fragmentation is, how it occurs, how to identify it, and methods to defragment your MySQL tables. What is Fragmentation in MySQL? Fragmentation in MySQL refers to the inefficient use of disk space within database tables, […]
Introduction Nowadays, MySQL is among the most popular and beloved databases for applications. But, managing and designing is a crucial and important task when selecting a database for your application. Let’s dig into what are the best practices to manage the database. MySQL Best Practices: Schema Design Indexing Performance Optimization Backup and Recovery Security Schema […]