SSD make difference!<\/p>\n
We’ve been hearing that SSD hard disks are new generation and therefor, all database intensive servers have to move to new SSD servers.\u00a0We gave it a shot and we never regret it!<\/p>\n
In hitsteps, we analyze thousands of hits per seconds. this hits then categorized and processed by a background processor, and archived somewhere along with millions of other hits!<\/p>\n
Given searching a visitor or looking back into archive of a visitor is an essential feature of hitsteps, we always had to struggle with performance of database searches, specially when searching for some visitors who visited\u00a0months ago.<\/p>\n
MySQL databases need RAM to hold all indexes of data, they also need a fast disk in case data are not in RAM. so we did the test in a mirrored server:<\/p>\n
Our search parameter was a simple query of “Searching for a visitor for who visited hitsteps dashboard who are from\u00a0Canada since 6\u00a0months ago”<\/strong><\/p>\n HDD server took 45 seconds to return query (almost near to timeout in most apache web server setups). SSD server took only 6 seconds to return query. Going to page number 2\u00a0in HDD took 15 seconds, in SSD just a wee 2 seconds.<\/p>\n It worth mentioning all other simple queries take less than 0.2 seconds in SSD servers and 0.5 in HDD servers.<\/p>\n Please do note that this times are closed source and relative to our script and codes. It might be different with other Applications, codes and scripts you might use in your server. RAM also play a major role here which is more appearance\u00a0if your server is using\u00a0HDD.<\/p>\n","protected":false},"excerpt":{"rendered":" SSD make difference! We’ve been hearing that SSD hard disks are new generation and therefor, all database intensive servers have to move to new SSD servers.\u00a0We gave it a shot and we never regret it! In hitsteps, we analyze thousands of hits per seconds. this hits then categorized and processed by a background processor, and … Continue reading How fast are SSD servers? Performance comparison between HDD vs SSD<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":207,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-201","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developers"],"_links":{"self":[{"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":1,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":204,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/posts\/201\/revisions\/204"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/media\/207"}],"wp:attachment":[{"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hitsteps.com\/blog\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}