by Monica Silva | Aug 11, 2022 | Blog, MySQL
The error log is an important tool for troubleshooting. The size of the error log file can get quite large if left unattended. For starters, there are not many parameters that can be adjusted to impact its size in any way, unlike the binlog that has a few system...
by Monica Silva | Jun 28, 2022 | Blog, MySQL
Binary logs play an important role in replication and data recovery. In replication, source databases communicate data changes recorded in its binary logs to the replica’s relay logs. They can also be used to repair a replica experiencing data drift. In a...
by Ken Haff | Jun 23, 2022 | Blog, SQL Server
You can also check out the Recorded Webinar. You may see events in your error logs reporting transient connection failures between cluster nodes or AlwayOn. You may observe high Asynch_Network_IO in [sys].[dm_os_wait_stats]. And you may have even brought it to the...
by Wes Moody | May 13, 2022 | Blog, SQL Server
When I was learning about Microsoft SQL Server issues a DBA needs to understand, I was reading about deadlocks. At first, I was confused because it sounded like the definition of blocking, which I was already more familiar with. I re-read it a couple of times and...
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 | Feb 18, 2022 | Blog, MySQL
For this example, the following software versions were in use: Ubuntu v20.04.3MySQL server v5.7.35Percona XtraBackup v2.4.24 It is important to note that Percona XtraBackup 8.0 is not compatible with MySQL version 5.7 and was introduced for use with MySQL version 8.0....
