Company
Date Published
Author
Nikita Shamgunov
Word count
682
Language
English
Hacker News points
None

Summary

SingleStore is a MySQL-compatible drop-in replacement designed to run fast in memory. A machine with 64 cores and 512 GB of RAM, similar to the Peak Hosting offering, was used to load half a billion records into SingleStore. The experiment aimed to compare loading efficiency between SingleStore and MySQL, using tricks such as multi-inserts, parallel loading, increased granularity, and a Python multiprocessing library-based load script. The results showed that SingleStore loaded data almost 200K inserts per second with a memory footprint of 267 GB, significantly faster than MySQL's 536 minutes to complete the same task.