Shane Rutter BlogMy place on the web

  • Home
  • About Me
  • Contact Me
  • Privacy Policy

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
Shane Rutter
Copyright 2025 © Shane Rutter