The Basics of Database Performance Tuning

The Basics of Database Performance Tuning

Poor database performance bogs down operations, and as the lifeblood of a business, companies can’t afford barriers to data access. One of the best ways to navigate past performance issues is by getting a regular database performance audit. Just like a car needs...
Verifying a Server is Offline

Verifying a Server is Offline

Overview From time to time, you’ll encounter a situation where a server appears to be offline, and you need to verify the validity of the alert prior to contacting proper support channels. This document covers certain steps that can be taken for verifying an...
Informix v11.70 End of Support (EOS)

Informix v11.70 End of Support (EOS)

Informix 11.70 database versions will be out of support as of September 30, 2020. For Informix users, this means IBM/HCL is discontinuing security updates, patches, and other services (even if you have an existing maintenance contract). For the Informix DBA, this...
Using the Mysqlbinlog Utility

Using the Mysqlbinlog Utility

MySQL binary logging is used for replication and also for point-in-time recovery of a MySQL database instance. It records any changes to database contents and may be recorded in a “statement-based” or “row-based” format. The default location to...