{"id":514,"date":"2008-02-07T17:43:24","date_gmt":"2008-02-07T22:43:24","guid":{"rendered":"http:\/\/blogs.n1zyy.com\/n1zyy\/2008\/02\/07\/tweaking-sql\/"},"modified":"2008-02-07T17:43:24","modified_gmt":"2008-02-07T22:43:24","slug":"tweaking-sql","status":"publish","type":"post","link":"https:\/\/blogs.n1zyy.com\/n1zyy\/2008\/02\/07\/tweaking-sql\/","title":{"rendered":"Tweaking SQL"},"content":{"rendered":"

I was thinking last night about solid-state drives. In their current form, they’re really not that much faster in terms of throughput<\/em>: a decent amount are actually even slower than ATA disks if you measure them in terms of MB\/sec throughput. Where they shine (100 times faster, at least) is seek time, though. So where they’re ideally suited for in a server environment right now is something with lots of random reads, where you might find yourself jumping all over the disk. For example, a setup with lots and lots of small files scattered across the disk.<\/p>\n

Many implementations of a database would be similar. Something like the database for this blog will have a lot of sequential reads: you’re always retrieving the most recent entries, so the reads tend to be fairly close. But there are lots of ways to slice the data that don’t result in reading neighboring rows or walking the table. (And what really matters is how it’s stored on disk, not how it’s stored in MySQL, but I’m assuming they’re one in the same.) Say I view my “Computers” category. That’s going to use reads from all over the table. Using a solid-state disk might give you a nifty boost there. So I think it’d be fun to buy a solid-state disk<\/a> and use it in an SQL server. I wager you’d see a fairly notable boost in performance, especially in situations where you’re not just reading sequential rows.<\/p>\n

But here’s the cool link<\/a> of this post. I’m not sure exactly what goes on here in a technical sense, but they use solid-state drives, getting the instant seek time, but they also get incredible throughput: 1.5GB\/sec is the slowest product they offer. I think there may be striping going on, but even then, with drives at 30MB\/sec throughput, that’d be 50 drives. The lower-end ones look to just be machines with enormous RAM (16-128 GB), plus some provisions to make memory non-volatile. But they’ve got some bigger servers, which can handle multiple terabytes of storage on Flash, and still pull 2GB\/sec of throughput, which they pretty clearly state isn’t counting stuff cached in RAM (which should be even faster).<\/p>\n

I want one.<\/p>","protected":false},"excerpt":{"rendered":"

I was thinking last night about solid-state drives. In their current form, they’re really not that much faster in terms of throughput: a decent amount are actually even slower than ATA disks if you measure them in terms of MB\/sec … Continue reading →<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4,5,11,12,16,19,22],"tags":[],"class_list":["post-514","post","type-post","status-publish","format-standard","hentry","category-business","category-computers","category-cool-links","category-insanity","category-interesting","category-materialism","category-performance","category-programming"],"_links":{"self":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/posts\/514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/comments?post=514"}],"version-history":[{"count":0,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/posts\/514\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/media?parent=514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/categories?post=514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.n1zyy.com\/n1zyy\/wp-json\/wp\/v2\/tags?post=514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}