Skip to content
tennant.io
  • Home
  • Projects

Databases

  • Home
  • Databases

Installing and Running MongoDB on MacOS

Posted by By Callum December 7, 2022Posted inTips & InstructionsNo Comments
MongoDB is most easily installed on MacOS by using Brew, a package manager for macOS that can be used to install, update, and manage software packages on your system. Brew…
Read More

How to Export Amazon RDS MySQL Results to CSV

Posted by By Callum March 17, 2022Posted inUncategorizedNo Comments
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…
Read More

How to Kill Many MySQL Processes at Once

Posted by By Callum October 1, 2021Posted inUncategorizedNo Comments
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…
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

AWS CSS 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 2025 — tennant.io. All rights reserved. Sinatra WordPress Theme
Scroll to Top