Shane Rutter BlogMy place on the web

  • Home
  • About Me
  • Contact Me
  • Privacy Policy

Servers

How I deleted 530 million records from a large MySQL database table hitting nearly 200GB

  • 19th January 2021
  • /
  • MySQL, Servers
  • /
  • No Comments

Came across the need to perform maintenance on a MySQL database which holds millions of records, we needed to remove all data which was 2+ years old which involved deleting around 530 million records from a very large table, hitting nearly 200GB.
Continue reading...

  • big data database db mysql server

cPanel – Sender x has an outgoing mail hold. Message will be reattempted later.

  • 5th January 2021
  • /
  • Linux, Servers
  • /
  • No Comments

A client was having issues sending emails and receiving a number of alerts regarding delayed emails. After looking investigating a number of outbound emails where queued with a failure reason of
Continue reading...

  • cpanel hosting php server whm

Ubuntu EC2 configure Amazon Time Sync Service for Amazon AWS

  • 10th November 2020
  • /
  • Laravel, Linux, Servers
  • /
  • No Comments

Having problems keeping your server time in sync? or a project requiring accurate timing? If your using a Amazon EC2 instance you can swap to using Chrony and Amazon Time Sync using the below commands.
Continue reading...

  • amazon amazon aws aws cloud server

Linux: Killall command

  • 31st August 2017
  • /
  • Guides, Tutorials & How To, Knowledge Base, Servers
  • /
  • No Comments

Manage your system better with the ability to kill processes on Linux easily with killall command, kill those unwanted processes freeing valuable resources.
Continue reading...

  • admin administration dedicated server Linux server
Shane Rutter
Copyright 2021 © Shane Rutter