Benchmarking CPU using Sysbench<\/strong><\/p>\nThis benchmark is configured with the number of simultaneous threads and the maximum number to verify if it is a prime.<\/p>\n
[root@localhost shiv]# sysbench --test=cpu --cpu-max-prime=2000000 --num-threads=120 run<\/pre>\nRunning the test with following options:\r\nNumber of threads: 120\r\nInitializing random number generator from current time\r\n\r\n\r\nPrime numbers limit: 2000000\r\n\r\nInitializing worker threads...\r\n\r\nThreads started!\r\n\r\nCPU speed:\r\n events per second: 0.69\r\n\r\nThroughput:\r\n events\/s (eps): 0.6891\r\n time elapsed: 174.1418s\r\n total number of events: 120\r\n\r\nLatency (ms):\r\n min: 169807.71\r\n avg: 172640.02\r\n max: 174120.65\r\n 95th percentile: 100000.00\r\n sum: 20716802.25\r\n\r\nThreads fairness:\r\n events (avg\/stddev): 1.0000\/0.00\r\n execution time (avg\/stddev): 172.6400\/0.83\r\n<\/pre>\n“time elapsed” is the variable we seriously look for to measure CPU performance, In this case it is 174.1418 seconds.<\/div>\n
<\/div>\n
Benchmarking threads performance using sysbench<\/strong><\/div>\nWhen we increase the threads workload,\u00a0each worker thread will be allocated a mutex (a sort of lock) and will, for each execution, loop a number of times (documented as the number of yields) in which it takes the lock, yields (meaning it asks the scheduler to stop itself from running and put it back and the end of the runqueue) and then, when it is scheduled again for execution, unlock.<\/div>\n
\n
[root@localhost shiv]# sysbench --test=threads --thread-locks=10 --max-time=60 run\r\n\r\nsysbench 1.1.0-651e7fd (using bundled LuaJIT 2.1.0-beta3)\r\n\r\nRunning the test with following options:\r\nNumber of threads: 1\r\nInitializing random number generator from current time\r\n\r\n\r\nInitializing worker threads...\r\n\r\nThreads started!\r\n\r\n\r\nThroughput:\r\n events\/s (eps): 2366.0725\r\n time elapsed: 60.0003s\r\n total number of events: 141965\r\n\r\nLatency (ms):\r\n min: 0.38\r\n avg: 0.42\r\n max: 8.86\r\n 95th percentile: 0.53\r\n sum: 59942.51\r\n\r\nThreads fairness:\r\n events (avg\/stddev): 141965.0000\/0.00\r\n execution time (avg\/stddev): 59.9425\/0.00\r\n<\/pre>\nTo conclude the interpretation of thread performance benchmarking, we annotate time elapsed (actual time for the completion of the activity), in this case it “60.0003” seconds.<\/p>\n<\/div>\n
Benchmarking mutex workload\u00a0<\/strong><\/div>\nWhen benchmarking mutex workload, sysbench will run a single request per thread. This request generates load on the CPU (using a simple incremental loop, through the
–mutex-loops<\/strong> parameter), after that it makes a random mutex, increments a global variable and release the lock again. This process is continued till the number of locks mentioned (–mutex-locks<\/strong>). The random mutex is generated by –mutex-num parameter.<\/div>\n <\/p>\n
[root@localhost shiv]# sysbench --test=mutex --num-threads=130 run\r\nWARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.\r\nWARNING: --num-threads is deprecated, use --threads instead\r\nsysbench 1.1.0-651e7fd (using bundled LuaJIT 2.1.0-beta3)\r\n\r\nRunning the test with following options:\r\nNumber of threads: 130\r\nInitializing random number generator from current time\r\n\r\n\r\nInitializing worker threads...\r\n\r\nThreads started!\r\n\r\n\r\nThroughput:\r\n events\/s (eps): 5.8047\r\n time elapsed: 22.3956s\r\n total number of events: 130\r\n\r\nLatency (ms):\r\n min: 17566.82\r\n avg: 20789.93\r\n max: 22230.90\r\n 95th percentile: 21641.55\r\n sum: 2702690.46\r\n\r\nThreads fairness:\r\n events (avg\/stddev): 1.0000\/0.00\r\n execution time (avg\/stddev): 20.7899\/0.82\r\n<\/pre>\nThe throughput and average latency are the two matrices we consider to interpret mutex workload performance :<\/p>\n
Throughput:\r\n events\/s (eps): 5.8047\r\n time elapsed: 22.3956s\r\n\r\nLatency (ms):\r\n min: 17566.82\r\n avg: 20789.93\r\n max: 22230.90\r\n 95th percentile: 21641.55\r\n sum: 2702690.46\r\n<\/pre>\n <\/p>\n
Benchmarking the memory workload\u00a0<\/strong><\/p>\nWhen we use sysbench to benchmark memory, sysbench allocate a memory buffer and then read or write from\/on it, each time for the size of a pointer (32 bit or 64 bit) and until the total buffer size has been read from or written to. \u00a0This activity will be continued till the provided volume (–memory-total-size) is reached. The load can be increased or reduced by providing multiple threads (–num-threads), size of buffer (–memory-block-size) and request type (read \/ write \/ sequential \/ random)<\/p>\n
[root@localhost shiv]# sysbench --test=memory --num-threads=140 --memory-total-size=10G run\r\n\r\nsysbench 1.1.0-651e7fd (using bundled LuaJIT 2.1.0-beta3)\r\n\r\nRunning the test with following options:\r\nNumber of threads: 140\r\nInitializing random number generator from current time\r\n\r\n\r\nRunning memory speed test with the following options:\r\n block size: 1KiB\r\n total size: 10240MiB\r\n operation: write\r\n scope: global\r\n\r\nInitializing worker threads...\r\n\r\nThreads started!\r\n\r\nTotal operations: 10485720 (3351958.44 per second)\r\n\r\n10239.96 MiB transferred (3273.40 MiB\/sec)\r\n\r\n\r\nThroughput:\r\n events\/s (eps): 3351958.4393\r\n time elapsed: 3.1282s\r\n total number of events: 10485720\r\n\r\nLatency (ms):\r\n min: 0.00\r\n avg: 0.01\r\n max: 2931.98\r\n 95th percentile: 0.00\r\n sum: 123371.54\r\n\r\nThreads fairness:\r\n events (avg\/stddev): 74898.0000\/0.00\r\n execution time (avg\/stddev): 0.8812\/0.93\r\n<\/pre>\nThroughput and operations per second are the important matrices to measure for memory workload benchmarking :<\/p>\n
Total operations: 10485720 (3351958.44 per second)\r\n\r\n10239.96 MiB transferred (3273.40 MiB\/sec)\r\n<\/pre>\n\n
Benchmarking file system I\/O with Sysbench<\/h3>\n
You can use multiple scenarios for benchmarking file system I\/O but here we have used rndrw \u00a0(combined random read \/ write) for more complex I\/O and production similar I\/O operations, This happens in three steps explained below:<\/p>\n
\n- Prepare<\/strong> – Creates the files for testing<\/li>\n
- Run<\/strong> – Performs the benchmarking and reporting<\/li>\n
- Cleanup<\/strong> – Clean the system by deleting the files<\/li>\n<\/ul>\n
Prepare\u00a0<\/em><\/p>\n[root@localhost shiv]# sysbench --num-threads=16 --test=fileio --file-total-size=10G --file-test-mode=rndrw prepare\r\n\r\nsysbench 1.1.0-651e7fd (using bundled LuaJIT 2.1.0-beta3)\r\n\r\n128 files, 81920Kb each, 10240Mb total\r\nCreating files for the test...\r\nExtra file open flags: (none)\r\nReusing existing file test_file.0\r\nReusing existing file test_file.1\r\nReusing existing file test_file.2\r\nReusing existing file test_file.3\r\n..................................\r\n..................................\r\n\r\nReusing existing file test_file.122\r\nReusing existing file test_file.123\r\nReusing existing file test_file.124\r\nReusing existing file test_file.125\r\nReusing existing file test_file.126\r\nReusing existing file test_file.127\r\n<\/pre>\nRun<\/em><\/p>\n[root@localhost shiv]# sysbench --num-threads=16 --test=fileio --file-total-size=10G --file-test-mode=rndrw run\r\n\r\nsysbench 1.1.0-651e7fd (using bundled LuaJIT 2.1.0-beta3)\r\n\r\nRunning the test with following options:\r\nNumber of threads: 16\r\nInitializing random number generator from current time\r\n\r\n\r\nExtra file open flags: (none)\r\n128 files, 80MiB each\r\n10GiB total file size\r\nBlock size 16KiB\r\nNumber of IO requests: 0\r\nRead\/Write ratio for combined random IO test: 1.50\r\nPeriodic FSYNC enabled, calling fsync() each 100 requests.\r\nCalling fsync() at the end of test, Enabled.\r\nUsing synchronous I\/O mode\r\nDoing random r\/w test\r\nInitializing worker threads...\r\n\r\nThreads started!\r\n\r\n\r\nThroughput:\r\n read: IOPS=2495.85 39.00 MiB\/s (40.89 MB\/s)\r\n write: IOPS=1663.70 26.00 MiB\/s (27.26 MB\/s)\r\n fsync: IOPS=5311.68\r\n\r\nLatency (ms):\r\n min: 0.00\r\n avg: 1.69\r\n max: 631.90\r\n 95th percentile: 5.00\r\n sum: 159794.48\r\n<\/pre>\nCleanup\u00a0<\/em><\/p>\n[root@localhost shiv]# sysbench --num-threads=16 --test=fileio --file-total-size=10G --file-test-mode=rndrw cleanup \r\nWARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.\r\nWARNING: --num-threads is deprecated, use --threads instead\r\nsysbench 1.1.0-651e7fd (using bundled LuaJIT 2.1.0-beta3)\r\n\r\nRemoving test files...\r\n<\/pre>\nIn the file system I\/O benchmarking, We spend time annotating and interpreting only throughput (both reads and writes) under varying loads, Here in the test above read throughput is 40.89 MB\/s and the write throughput is 27.26 MB\/s<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
We already have written blog on Sysbench (https:\/\/minervadb.com\/index.php\/2018\/03\/13\/benchmarking-mysql-using-sysbench-1-1\/) , so in this blog we are not covering basic details like installation and configuration of Sysbench. In this blog we are just specific on benchmarking CPU, […]<\/a><\/p>\n<\/div>","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,15,56,104,103],"tags":[5,105,106],"yoast_head":"\nEnterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse<\/title>\n<meta name=\"description\" content=\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Benchmarking CPU, Memory, file I\/O and mutex performance using Sysbench\" \/>\n<meta property=\"og:description\" content=\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-27T13:25:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-28T17:34:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"MinervaDB Corporation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/WebScaleDBA\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"MinervaDB Corporation\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\"},\"author\":{\"name\":\"MinervaDB Corporation\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce\"},\"headline\":\"Benchmarking CPU, Memory, file I\/O and mutex performance using Sysbench\",\"datePublished\":\"2018-03-27T13:25:52+00:00\",\"dateModified\":\"2018-03-28T17:34:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\"},\"wordCount\":496,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"keywords\":[\"MySQL\",\"MySQL Performance Benchmarking\",\"Sysbench\"],\"articleSection\":[\"MySQL\",\"MySQL Performance\",\"MySQL performance audit\",\"MySQL Performance Benchmarking\",\"Sysbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\",\"url\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\",\"name\":\"Enterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"datePublished\":\"2018-03-27T13:25:52+00:00\",\"dateModified\":\"2018-03-28T17:34:48+00:00\",\"description\":\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\",\"breadcrumb\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Benchmarking CPU, Memory, file I\/O and mutex performance using Sysbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce\",\"name\":\"MinervaDB Corporation\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g\",\"caption\":\"MinervaDB Corporation\"},\"description\":\"Independent and vendor neutral consulting, support, remote DBA services and training for MySQL, MariaDB, Percona Server, PostgreSQL and ClickHouse with core expertize in performance, scalability and high availability . We are an virtual corporation, all of us work from home on multiple timezones and stay connected via Email, Skype, Google Hangouts, Phone and IRC supporting over 250 customers worldwide\",\"sameAs\":[\"https:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/WebScaleDBA\"],\"url\":\"http:\/\/minervadb.com\/index.php\/author\/minervadb\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Enterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse","description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/","og_locale":"en_US","og_type":"article","og_title":"Benchmarking CPU, Memory, file I\/O and mutex performance using Sysbench","og_description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","og_url":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_published_time":"2018-03-27T13:25:52+00:00","article_modified_time":"2018-03-28T17:34:48+00:00","og_image":[{"width":200,"height":200,"url":"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg","type":"image\/jpeg"}],"author":"MinervaDB Corporation","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/WebScaleDBA","twitter_site":"@webscaledba","twitter_misc":{"Written by":"MinervaDB Corporation","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#article","isPartOf":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/"},"author":{"name":"MinervaDB Corporation","@id":"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce"},"headline":"Benchmarking CPU, Memory, file I\/O and mutex performance using Sysbench","datePublished":"2018-03-27T13:25:52+00:00","dateModified":"2018-03-28T17:34:48+00:00","mainEntityOfPage":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/"},"wordCount":496,"commentCount":0,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"keywords":["MySQL","MySQL Performance Benchmarking","Sysbench"],"articleSection":["MySQL","MySQL Performance","MySQL performance audit","MySQL Performance Benchmarking","Sysbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/","url":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/","name":"Enterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"datePublished":"2018-03-27T13:25:52+00:00","dateModified":"2018-03-28T17:34:48+00:00","description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","breadcrumb":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/minervadb.com\/index.php\/2018\/03\/27\/benchmarking-cpu-memory-file-i-o-and-mutex-performance-using-sysbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Benchmarking CPU, Memory, file I\/O and mutex performance using Sysbench"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/9cae1c69d8b5c86168963f97bf75b9ce","name":"MinervaDB Corporation","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/0d00cba8b96118c4c4ed6d6be8f771ce?s=96&d=blank&r=g","caption":"MinervaDB Corporation"},"description":"Independent and vendor neutral consulting, support, remote DBA services and training for MySQL, MariaDB, Percona Server, PostgreSQL and ClickHouse with core expertize in performance, scalability and high availability . We are an virtual corporation, all of us work from home on multiple timezones and stay connected via Email, Skype, Google Hangouts, Phone and IRC supporting over 250 customers worldwide","sameAs":["https:\/\/minervadb.com","https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/https:\/\/twitter.com\/WebScaleDBA"],"url":"http:\/\/minervadb.com\/index.php\/author\/minervadb\/"}]}},"_links":{"self":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/1205"}],"collection":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=1205"}],"version-history":[{"count":3,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/1205\/revisions"}],"predecessor-version":[{"id":1246,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/1205\/revisions\/1246"}],"wp:attachment":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=1205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=1205"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=1205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}