5 ms·
>if i recall from early Zynga (circa 2008), we would get MySQL (InnoDB) on decent commodity hardware (Dell 2U with 8 cores, 32G mem, 15K RPM disks in raid 10, c
by asdasf 13y ago
>if i recall from early Zynga (circa 2008), we would get MySQL (InnoDB) on decent commodity hardware (Dell 2U with 8 cores, 32G mem, 15K RPM disks in raid 10, cost about $7K USD) to around 6K QPS before it would eat shit.
Mysql is slow for concurrent access, but not that slow. I don't have mysql installed, but postgresql running on openbsd (a famously poorly performing OS) in a virtualbox virtual machine (hooray overhead) only being given one core and running off of a slow laptop hardrive is beating that for me.
- nrser 13y agohow big is your data set? i remember MySQL degrading when the tables got too big, i think around 100M rows or so. the data set probably didn't fit in memory either. i don't know how much of a difference it makes, but we were also moving all the data across the wire (vs. what i'm guessing is local access on your machine), and probably about 50% writes. i might be off on the 6K number... this was all some years ago, so it's a little fuzzy... but i don't think it was 'tens or hundreds of thousands' by any means.