Mongodb crashes due to too many open files error
Problem When running MongoDB in production, configuring the open file descriptor limit (nofile) is critical. Ubuntu's default limit (10...
Read MoreShowing posts with label Database Administration. Show all posts
MySQL Binlog Restore using Python
Its easy to recover mysql data like Amazon RDS , Its Sort and Easy Method if you are not able to understand manual method https://github.com...
Read MoreSteps to Change TempDB Location in SQL Server
Its very easy and simple , Just sharing you the steps without so much theories Why we are moving it , when its in C Drive or SQL Data Drive...
Read MoreSQL Server High CPU Issue Caused by Implicit Conversion (nvarchar vs varchar)
Problem Overview Recently, we encountered a high CPU utilization issue on a SQL Server instance — even though only one small SELECT quer...
Read More
How to upgrade MySQL from 8.0 to 8.4 ?
Dear all my DBA Friends its time to upgrade to 8.4 . Yes We are getting notification from all the cloud partners as well on the customer sid...
Read MoreMySQL ERROR 1146 (42S02): Table 'datablogs.tbl_followup' doesn't exist
Had a some conversation with friend he is facing this issue for long back and unable to solve it . But i had an thought why we cant replicat...
Read More
PostgreSQL Table Partition on AWS RDS
If we grow bigger in the business , seamlessly our customer and transaction data also increases . In the meantime performance needs to consi...
Read MoreOracle RDS Audit log enable
Oracle Audit Log : Oracle Audit Log refers to the feature in Oracle Database that records and stores information about various database act...
Read MoreHow to Automate MongoDB Database Backups in Linux
We have setup of One Primary with Multiple Secondary Even if we configured highly available setup and backups , native backup are so specia...
Read MoreRestore and Point in time Restore with Percona Backup of MongoDB on another instance
Its easy to recover MongoDB Backup using Percona Backup for MongoDB https://medium.com/@datablogs/restore-and-point-in-time-restore-with-per...
Read More
How to tune long running Queries on Azure Synapse DW (Dedicated Pool) - Part 2
Its took little long time to derive our approach tunning on azure data factory with Azure Synapse why because we need to run the system atle...
Read MoreUpdate Backup and Restore in Same SQL Server RDS
Update of Previous post , As mentioned in below blog , past years we cant restore database into same SQL Server RDS https://medium.com/@yog...
Read MoreORA-01940 cannot drop a user that is currently connected
Its Easy to achieve it in easy method , https://datablogs.medium.com/ora-01940-cannot-drop-a-user-that-is-currently-connected-and-kill-inact...
Read More
How to tune long running Queries on Azure Synapse DW (Dedicated Pool) - Part 1
Three hours of long running pipeline is reduced to run in 35 Minutes when we given right kind of top bottom optimization like our Body !!! ...
Read More