Tag

bash script

1 views collected around this technical thread.

Wukong Talks Architecture

Jun 6, 2024 · Operations

How to Prevent Accidental Database Deletion: Backup Strategies and Automation

This guide explains why accidental database deletion is a critical risk, outlines permission and audit measures, and provides detailed MySQL and file backup solutions—including encryption, multi‑site storage, cron scheduling, and ready‑to‑run Bash scripts—to ensure data safety and system stability.

CronDockerMySQL

0 likes · 9 min read

How to Prevent Accidental Database Deletion: Backup Strategies and Automation

Qunar Tech Salon

Apr 14, 2017 · Databases

Analyzing a 5‑Second Delay in MySQL Binlog Update Rows with a Bash Summarizer

The article explains why a MySQL UPDATE statement took five seconds by examining binlog entries, distinguishing slow‑query scans from lock‑waits, and using a Bash script to identify long‑running transactions that reveal hidden lock contention.

BinlogDBAMySQL

0 likes · 8 min read

Analyzing a 5‑Second Delay in MySQL Binlog Update Rows with a Bash Summarizer