Monitor MySQL And Auto Recover From A Crash

Since starting this blog in July of 2014, I have had an unexpected amount of growth. So much, that a lot of strain has been placed on my virtual private server (VPS).

A common issue that has plagued me and many other WordPress users is the awful MySQL crash due to exhausted resources. This is because the server has run out of resources due to traffic spikes or other anomalies. The worst part for me is that MySQL tends to crash while I’m sleeping, putting my blog out of commission for up to six hours at a time. This is not good when you’re trying to be a reliable source of information on the internet.

Luckily, I’ve developed a script that will elegantly resolve these related problems.

Find All Tables In An Oracle Database By Column Name

I work with very large Oracle enterprise databases all the time. Consistently, I find myself trying to sift through schemas in the database to find relationships between tables. When tables aren’t named appropriately and you have a lot of them, this can be a long and painful process if you do it manually.

Lucky for us, there is a convenient way to search for the tables you’re looking for based on column information.

Get The Most Recent Record In A Table By Date And User

I often find myself working with legacy database tables that don’t have primary keys or auto increment keys. In addition to this, I always find myself needing to get the latest record for a particular set of data in my database. It is never as easy as just calling a max in the where clause. A subquery is often needed to get the most recent record in a table.