Living to Learn | Learning to Live
Home
Blogs
Projects
←
mysql
07
Dec 2021
How to automatically maintain a MySQL Table’s Partitions?
sanyamaggarwal.medium.com
There cannot be an infinite number of partitions, so partitioning comes with the overhead of maintenance. Manual Partiti...
Nov
2021
MySQL Partition Keeper
github.com
NodeJS script run by a cron job to automatate MySQL Partition Maintenance
mysql
nodejs
javascript
08
Nov 2021
Partitioning — Reduce query time by 2000x in a MySQL table with 500M+ rows
sanyamaggarwal.medium.com
There was one incident where the API which fetched the data for our homepage was very slow, leading to users restarting...
Oct
2020
Social Media App
github.com
A social media application powered by NodeJS and MySQL
mysql
nodejs
javascript
html