by Monica Silva | Apr 14, 2022 | Blog, Database, MySQL
When performing health checks on a database, I look at how many users are granted SUPER privileges. If you’re reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to...
by XTIVIA | Sep 24, 2020 | Blog, Database
As a critical component of your business, a healthy database is vital to staff efficiency and customer satisfaction. If you’ve neglected database maintenance and tuning, chances are you’re running into a litany of performance issues. When your database...
by XTIVIA | May 30, 2017 | Blog, MongoDB
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...
by XTIVIA | Mar 14, 2017 | Blog, Db2, Informix, MongoDB, MySQL, Oracle, SQL Server
Ahhhhhh—the fresh smell of a brand new laptop, being pulled out of its box for the first time. Breathe it in. Your tax return really paid off this year, but your shopping doesn’t end with this new device. On the contrary, you’ve got a spree ahead of you. This laptop...
by XTIVIA | Apr 19, 2016 | Blog, SQL Server
Just as your car needs its oil changed, tires rotated, and fluids checked every few thousand miles, your database is a complex machine that relies on maintenance to function well. A health check is important to pinpoint problem areas so you can supplement your...