Run a shell script in the background on Linux
Typically, I will need to run a shell script on a Linux server which I know will take a while to execute. I will sometimes also need to check up…
How to Export Amazon RDS MySQL Results to CSV
Over the past couple of months, I have been tasked with moving our server stack over from Digital Ocean VPS hosting to AWS. What used to be just one single…
How to Kill Many MySQL Processes at Once
We recently had an issue on our database server which meant many slow MySQL queries had built up (up to 50 of them!) These slow queries were preventing other queries…
Timing Linux Script Execution
I am in the process of improving the speed of a MySQL remote connection which connects to an external server on the internet. In order to test the speed of…
How to Kill an Unresponsive SSH Session
SSH sessions can become unresponsive or hang for a number of reasons; one reason being network issues which I experience frequently when working from an unstable Wi-Fi network. The following…
Using USB drives as a boot drives
I was running two Ethereum mining rigs with USB drives as their boot drives for several months and, after around 2-3 months, both of them began experiencing I/O related issues.…
Reducing the size of a MySQL database when it is Too Large
Recently, our server ran out of storage space due to a unnecessarily huge database and I was tasked with diagnosing and remediating the issue. I needed to: Determine the remaining…
Quick MongoDB Naming Conventions
I have written this post to serve as some quick guidelines for how databases and collections should be named in MongoDB to keep my projects consistent. Partially derived from this…
Different MySQL Results but Same Query & Data
I was recently asked to look at an issue causing results on two MySQL servers (hosted on different machines: local environment and production environment) to be inconsistent with one another…
Exporting MySQL Results to CSV
Before exporting the query results to a CSV file, you must firstly determine if the secure_file_priv option is set by running the following SQL query: SHOW VARIABLES LIKE 'secure_file_priv'; If…