{"id":498,"date":"2014-12-31T15:15:08","date_gmt":"2014-12-31T15:15:08","guid":{"rendered":"http:\/\/www.tech-g.com\/?p=498"},"modified":"2015-01-08T15:13:10","modified_gmt":"2015-01-08T15:13:10","slug":"flash-sticks-speed-tests-and-use-with-mysql","status":"publish","type":"post","link":"https:\/\/www.voodoo.business\/blog\/2014\/12\/31\/flash-sticks-speed-tests-and-use-with-mysql\/","title":{"rendered":"Flash sticks speed tests and use with MySQL"},"content":{"rendered":"<p>So i need a few SSDs for a certain project that i will be starting in a few months, but before i shell some money into SSDs while i have so many SSDs and USB flash drives, I want to try and replace the SATA SSDs with USB flash sticks and see how it goes, if all goes well, i will be using the FLASH sticks in place of the SSDs and take the SSDs into my new project.<\/p>\n<p>What i will be testing later on is<\/p>\n<p>1- Speed<\/p>\n<p>2- Reliability (They will write once read millions of times on this MySql server).<\/p>\n<p>But first, i took out all my flash sticks, and decided to run speed tests on them (With the DD command).<\/p>\n<p>Most of the candidate sticks are USB3, but one of the host machines does not have USB3 ports, so i will test every stick on USB2 and USB3 before i use them.<\/p>\n<p>So, basically, the test results are as follows. Even when the data transfer rate does not exceed the USB2 specification, the USB 3 sticks function better on a USB port.<\/p>\n<p>Please note that USB flash disks do not have wear leveling functionality, they are only for that tables that are not written into often (but read many times)<\/p>\n<p>I will be installing the USB 3 drives on the production machines now and I will report any failures caused by the USB flash disks.<\/p>\n<p>For SD cards, i used the USB reader (FOR MRG1 31123-004. A001F 121412 5V CHINA)<\/p>\n<table border=\"1\" width=\"100%\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td><\/td>\n<td>Short Name<\/td>\n<td>Size<\/td>\n<td>Speed Read USB 2<\/td>\n<td>Speed Write USB2<\/td>\n<td>Speed Read USB 3<\/td>\n<td>Speed Write USB3<\/td>\n<\/tr>\n<tr bgcolor=\"#FFFF00\">\n<td>Lexar Korea &#8211; LJDS33-64G 100-104 B 33800-64GBA 1813SV:05dc P:a833<\/td>\n<td>S33 64G<\/td>\n<td>64G<\/td>\n<td>35.17<\/td>\n<td>19.30<\/td>\n<td>U3 106.89<\/td>\n<td>U3 26.11<\/td>\n<\/tr>\n<tr bgcolor=\"#FFFF00\">\n<td>Lexar OrangeV:05dc P:a205<\/td>\n<td><\/td>\n<td>32G<\/td>\n<td>32.60<\/td>\n<td>19.10<\/td>\n<td>U3 43.37<\/td>\n<td>U3 24.55<\/td>\n<\/tr>\n<tr>\n<td>Lexar 32GB Class 10 8296952A SD card with our card readercard reader V:05e3 P:0736<\/td>\n<td><\/td>\n<td>32G<\/td>\n<td>17.48<\/td>\n<td>9.98<\/td>\n<td>SD 18.85<\/td>\n<td>SD 11.38<\/td>\n<\/tr>\n<tr bgcolor=\"#FFFF00\">\n<td>V:05dc P:a205<\/td>\n<td><\/td>\n<td>16G<\/td>\n<td>32.60<\/td>\n<td>15.47<\/td>\n<td>U3 43.39<\/td>\n<td>U3 17.27<\/td>\n<\/tr>\n<tr>\n<td>SanDisk 16GB Cruzer Blade V:0781 P:5567<\/td>\n<td><\/td>\n<td>16G<\/td>\n<td>20.68<\/td>\n<td>6.77<\/td>\n<td>21.53<\/td>\n<td>7.58<\/td>\n<\/tr>\n<tr bgcolor=\"#FFFF00\">\n<td>Lexar (Orange) V:05dc P:a833<\/td>\n<td><\/td>\n<td>8G<\/td>\n<td><\/td>\n<td><\/td>\n<td>U3 93.07<\/td>\n<td>U3 8.99<\/td>\n<\/tr>\n<tr bgcolor=\"#FFFF00\">\n<td>Lexar (Blue) V:05dc P:a205<\/td>\n<td><\/td>\n<td>8G<\/td>\n<td>32.60<\/td>\n<td>10.84<\/td>\n<td>U3 42.41<\/td>\n<td>U3 10.99<\/td>\n<\/tr>\n<tr>\n<td>Lexar S70 V:05dc P:a202<\/td>\n<td><\/td>\n<td><\/td>\n<td>17.90<\/td>\n<td>5.73<\/td>\n<td>17.97<\/td>\n<td>5.23<\/td>\n<\/tr>\n<tr>\n<td>Old lexar V:05dc P:c75a (Stick 142)<\/td>\n<td><\/td>\n<td>8G<\/td>\n<td>20.37<\/td>\n<td>4.53<\/td>\n<td>21.11<\/td>\n<td>4.69<\/td>\n<\/tr>\n<tr>\n<td>Sony 8GB Class 10 cardcard reader<\/td>\n<td><\/td>\n<td>8G<\/td>\n<td>18.73<\/td>\n<td>7.57<\/td>\n<td>19.23<\/td>\n<td>7.30<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So i need a few SSDs for a certain project that i will be starting in a few months, but before i shell some money into SSDs while i have so many SSDs and USB flash drives, I want to try and replace the SATA SSDs with USB flash sticks and see how it goes, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-498","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/posts\/498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/comments?post=498"}],"version-history":[{"count":4,"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/posts\/498\/revisions"}],"predecessor-version":[{"id":505,"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/posts\/498\/revisions\/505"}],"wp:attachment":[{"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/media?parent=498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/categories?post=498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.voodoo.business\/blog\/wp-json\/wp\/v2\/tags?post=498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}