Skip to content

tennant.io

  • Home
  • Projects

Timing Linux Script Execution

Posted by By Callum September 7, 2021Posted inUncategorizedNo Comments
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…
Read More

How to Kill an Unresponsive SSH Session

Posted by By Callum September 3, 2021Posted inUncategorizedNo Comments
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…
Read More

Using USB drives as a boot drives

Posted by By Callum April 21, 2021Posted inUncategorizedNo Comments
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.…
Read More

Reducing the size of a MySQL database when it is Too Large

Posted by By Callum April 2, 2021Posted inUncategorizedNo Comments
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…
Read More

Quick MongoDB Naming Conventions

Posted by By Callum June 30, 2020Posted inSoftware DevelopmentNo Comments
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…
Read More

Different MySQL Results but Same Query & Data

Posted by By Callum May 18, 2020Posted inSoftware DevelopmentNo Comments
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…
Read More
MySQL to CSV

Exporting MySQL Results to CSV

Posted by By Callum May 16, 2020Posted inSoftware DevelopmentNo Comments
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…
Read More

Posts navigation

Previous page 1 2

AWS Databases Git JavaScript linux MacOS MongoDB MySQL Programming Shell Scripts

Popular Posts

Quick MongoDB Naming Conventions

How to Export Amazon RDS MySQL Results to CSV

Copyright 2023 — tennant.io. All rights reserved. Sinatra WordPress Theme
Scroll to Top