Archiving Historical MySQL Data with pt-archiver Tool
Background
Starting from December 5th, a production instance began experiancing daily replica lag alerts. After investigation, the TPS during the lag period was not high, with only about 1K DML operations on the clickstream_events table. However, this table had grown to 60GB, far exceeding the recommended maximum single table size of 10GB.
This ...
Posted on Wed, 16 Sep 2026 16:05:06 +0000 by fpyontek
Importing Question Banks into MySQL with Auto-Incrementing IDs
Data Normalization Strategy
To bulk import a question bank into a database via a text file, the raw data must first be converted into a delimited format suitable for parsing. We will use the hash symbol (#) as the field delimiter. The final structure for each record should correspond to the following schema:
QuestionContent#OptionA#OptionB#Opti ...
Posted on Tue, 07 Jul 2026 17:32:47 +0000 by shana