{"id":552,"date":"2014-05-09T08:10:49","date_gmt":"2014-05-09T08:10:49","guid":{"rendered":"http:\/\/10sa.com\/sql_stories\/?p=552"},"modified":"2014-06-03T18:29:06","modified_gmt":"2014-06-03T18:29:06","slug":"performance-test","status":"publish","type":"post","link":"http:\/\/10sa.com\/sql_stories\/?p=552","title":{"rendered":"Performance test"},"content":{"rendered":"<p>First of all I use my own script (called quick-confession) which get me info about processors, ram, discs, etc.<br \/>\nYou can get it <a href=\".\/q-c.sh\">here<\/a>. It contains the instruction how to compile sysbench.<br \/>\nI am also used to test the configuration with iozone and filebench.<\/p>\n<p>I am using xfs for database storage and tune it as per the following site: http:\/\/www.mysqlperformanceblog.com\/2011\/12\/16\/setting-up-xfs-the-simple-edition\/<br \/>\nNow, I introduce iscsi in production and think that a\/m tuning also is good for the iscsi initiatior.<\/p>\n<p>With iozone you must be careful about the system cache. I use the following trick:<br \/>\n-w &#8211; leave the files<br \/>\n-i0 &#8211; create files (and write test together)<br \/>\n\/tmp\/iozone -w -i0 -i5 -s 32m -r 16k -l 32<br \/>\nsync; echo 3 > \/proc\/sys\/vm\/drop_caches<br \/>\n\/tmp\/iozone -w -i5 -s 32m -r 16k -l 32 # I omit -i0<\/p>\n<p>You can obtain some charts with report.pl included together with iozone binaries.<br \/>\nLet see, I have 2 storages: \/db_storage and \/db_storage_ssd\/<br \/>\nFirst get statistics from \/db_storage<br \/>\ncd \/db_storage<br \/>\n\/tmp\/iozone -w -i0 -i5 -s 32m -r 16k -l 32 > \/location_with_iozone_sources\/testSTORAGE<br \/>\ncd \/db_storage_ssd<br \/>\n\/tmp\/iozone -w -i0 -i5 -s 32m -r 16k -l 32 > \/location_with_iozone_sources\/testSTORAGEssd<br \/>\ncd \/location_with_iozone_sources<br \/>\nperl .\/report.pl testSTORAGE testSTORAGEssd<br \/>\ncd .\/test_STORAGE_testSTORAGE_ssd<br \/>\nls -l<br \/>\nvoila \ud83d\ude42<\/p>\n<p>ps. last time i discovered fio benchmark<br \/>\nhttp:\/\/www.linux.com\/learn\/tutorials\/442451-inspecting-disk-io-performance-with-fio\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First of all I use my own script (called quick-confession) which get me info about processors, ram, discs, etc. You can get it here. It contains the instruction how to compile sysbench. I am also used to test the configuration with iozone and filebench. I am using xfs for database storage and tune it as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,18],"tags":[],"_links":{"self":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/552"}],"collection":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=552"}],"version-history":[{"count":14,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/552\/revisions"}],"predecessor-version":[{"id":824,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/552\/revisions\/824"}],"wp:attachment":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=552"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}