MongoDB:  Mtools and Slow Queries

MongoDB: Mtools and Slow Queries

Mtools is a third party tool suite that contains very easy to use utilities for troubleshooting or just gathering general knowledge about your MongoDB instance. These tools can be crucial when performance tuning, running a health check or examining log files. You can...
MongoDB Sudden Slow Database Performance

MongoDB Sudden Slow Database Performance

Sometimes you may notice that everything in MongoDB is running fine, then you suddenly have performance issues that come up out of nowhere. There can be several reasons why this happens but I am going to cover a few of the common ones here. Long-running queries Index...
Troubleshooting Slow Queries in MongoDB

Troubleshooting Slow Queries in MongoDB

There are many reasons why your database queries can start to lag or experience throughput issues. In this article I will do troubleshooting on two common issues with slow queries and a way to fix each one. When doing any performance tuning on a database it’s...
MongoDB ServerStatus Health Check Tips

MongoDB ServerStatus Health Check Tips

MongoDB ServerStatus is the main command used to produce a huge document containing important metrics and information about your database. When performing a health check, there are several important keys that you’ll want to be aware of inside serverStatus. The...
ERROR 1114 – The table is full

ERROR 1114 – The table is full

At XTIVIA, we have encountered the MySQL Error 1114, “table is full” on quite a few occasions. The description for the error is usually misleading as it implies that a table has reached or exceeded a maximum set limitation. Tables utilizing the InnoDB...
Changing Storage in an Always On Environment

Changing Storage in an Always On Environment

I was recently given a task to move a few multi-terabyte databases inside of an availability group from SAN A to SAN B within a 10-minute window. The good news was there was plenty of time to plan and prepare. For the purpose of this example, I will be using a very...
ORA-01017: Invalid Username/Password; Logon Denied

ORA-01017: Invalid Username/Password; Logon Denied

Oracle ORA-01017 Quick Fix The ORA-01017 error seems pretty straight forward, however it can have us banging our heads against our desks for awhile trying to figure out why we can’t seem to type our password in correctly. Here are a few reasons I have personally...