4 ms·
got your point actually, you can see all the data here: http://db.lloogg.com http://db.lloogg.com, there are many stats about load, disk I/O, and so on.
by antirez 17y ago
got your point actually, you can see all the data here: http://db.lloogg.com http://db.lloogg.com, there are many stats about load, disk I/O, and so on.
- easp 17y agoThat sheds some light on things. One thing that doesn't make sense to me is that your disk writes are completely flat now, no real variation through the day.
- sounddust 17y agoThat's much more interesting data, but it clearly shows that the reason Redis was performing better is because it's caching a ton of data in memory, whereas MySQL was constantly hitting the disk for access. This seems to be a misconfiguration of either your kernel settings or MySQL settings. If Redis effectively cached your entire dataset in RAM, then MySQL could have done so as well (or the kernel could have). I'm guessing that you configured MySQL in a way that caused the kernel to fight with the database over memory usage.