BestHub
Sign in
Tag

CRC32

0 views collected around this technical thread.

vivo Internet Technology
vivo Internet Technology
Jul 3, 2024 · Databases

End-to-End Data Consistency Verification for MySQL in DTS

The Vivo Internet Storage R&D team's article describes an end‑to‑end MySQL data‑consistency verification tool for DTS that uses fixed‑size chunking and CRC32/MD5 fingerprint aggregation to quickly compare source and target tables, pinpoint mismatched rows, and enable automated or manual correction while minimizing impact on replication.

CRC32ChunkingDTS
0 likes · 13 min read
End-to-End Data Consistency Verification for MySQL in DTS
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 12, 2021 · Databases

Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL

The article explains how to improve indexing of long string columns in MySQL by using generated columns with CRC32/MD5 hashes, functional indexes introduced in MySQL 8.0.13, and prefix indexes, providing code examples and performance considerations.

CRC32Function IndexGenerated Column
0 likes · 4 min read
Using CRC32/MD5 Hashes and Prefix Indexes for Efficient Long String Indexing in MySQL
Python Programming Learning Circle
Python Programming Learning Circle
May 30, 2020 · Backend Development

Analyzing Bilibili Comment API and Building a Search Tool

This article describes how to discover Bilibili's comment XML APIs, decode the embedded CRC32‑hashed user IDs, choose an appropriate database schema, and implement a Python‑PHP tool that retrieves, filters, and displays comments based on video CID and keyword.

APIBilibiliCRC32
0 likes · 6 min read
Analyzing Bilibili Comment API and Building a Search Tool