corpus.blog
41554 blogs · [ { "id": "01a087bc-30b7-721c-94cb-051a568663ec", "title": "Project: UPI Daily Spend Tracker", "url": "https://pankajtw.github.io/projects/2026/02/12/UPI-Spend-Tracker.html", "published_at": "2026-02-12T00:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a5782236d", "title": "Fixing Prod Query Slowdowns Caused by MySQL open_files_limit", "url": "https://pankajtw.github.io/mysql/performance%20tuning/rca/2025/11/03/Prod-Issue-Due-To-Open-files-limit.html", "published_at": "2025-11-03T00:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a57b30b74", "title": "How pt-heartbeat Log Rotation Caused Disk Space Bloat on Our MySQL Nodes", "url": "https://pankajtw.github.io/mysql/percona/monitoring/linux/2025/10/10/pt-heartbeat-log-rotation-disk-space-bloat.html", "published_at": "2025-10-10T00:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a581edb0b", "title": "Unexpected MySQL Restarts on Ubuntu 24.04: The needrestart Change", "url": "https://pankajtw.github.io/mysql/ubuntu/devops/2025/10/03/Unexpected-MySQL-Restarts.html", "published_at": "2025-10-03T00:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a5918c151", "title": "How innodb-flush-log-at-trx-commit saved the day", "url": "https://pankajtw.github.io/2025/08/18/How-InnoDB-flush-log-at-trx-commit-saved-the-day.html", "published_at": "2025-08-18T12:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a59ff83e4", "title": "MySQL to RDS Replication Script using XtraBackup and S3", "url": "https://pankajtw.github.io/2025/06/04/RDS-Replication-Script.html", "published_at": "2025-06-04T00:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a5a706761", "title": "When a MySQL Replica Became Primary and Blew Up the Disk with Audit Logs", "url": "https://pankajtw.github.io/2025/05/08/MySQL-Audit-Log-Disaster.html", "published_at": "2025-05-08T00:00:00+00:00" }, { "id": "01a087bc-30b7-721c-94cb-051a5a8dfda9", "title": "Mysql Primary Promotion Using GTID", "url": "https://pankajtw.github.io/2025/05/05/MySQL-Primay-Promotion-Using-GTID.html", "published_at": "2025-05-05T08:30:00+00:00" } ] posts Claim your blog
Back to The DataNinja | Deep dives into database technologies like MySQL, GTID replication, high availability, and disaster recovery. Also covering OLAP solutions like Snowflake, distributed systems, Kafka-based event-driven architectures, and cloud infrastructur
Blog · corpus.blog/blogs/pankajtw.github.io/posts

The DataNinja | Deep dives into database technologies like MySQL, GTID replication, high availability, and disaster recovery. Also covering OLAP solutions like Snowflake, distributed systems, Kafka-based event-driven architectures, and cloud infrastructur

pankajtw.github.io

2026

Project: UPI Daily Spend Trackeroriginal ↗
12 Feb 2026

2025

Fixing Prod Query Slowdowns Caused by MySQL open_files_limitoriginal ↗
3 Nov 2025
How pt-heartbeat Log Rotation Caused Disk Space Bloat on Our MySQL Nodesoriginal ↗
10 Oct 2025
Unexpected MySQL Restarts on Ubuntu 24.04: The needrestart Changeoriginal ↗
3 Oct 2025
How innodb-flush-log-at-trx-commit saved the dayoriginal ↗
18 Aug 2025
MySQL to RDS Replication Script using XtraBackup and S3original ↗
4 Jun 2025
When a MySQL Replica Became Primary and Blew Up the Disk with Audit Logsoriginal ↗
8 May 2025
Mysql Primary Promotion Using GTIDoriginal ↗
5 May 2025