{"id":3138,"date":"2018-09-21T08:36:29","date_gmt":"2018-09-21T08:36:29","guid":{"rendered":"http:\/\/dbtut.com\/?p=3138"},"modified":"2019-04-11T07:15:01","modified_gmt":"2019-04-11T07:15:01","slug":"benchmark-performance-of-mysql-using-sysbench","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/","title":{"rendered":"Benchmark performance of MySQL using SysBench"},"content":{"rendered":"

Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the\u00a0maximal QPS(Query Per Second), concurrent threads and so on. Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.<\/p>\n

1. Check the server information:<\/h2>\n

System:<\/b><\/p>\n

CPU: 64 core(Intel(R) Xeon(R) Gold 6130 CPU @ 2.10GHz)<\/p>\n

MEMORY: 128GB<\/p>\n

\n

\"\"<\/p>\n

<\/div>\n<\/div>\n

MySQL instance:<\/b><\/p>\n

Version: 5.7.23<\/p>\n

innodb_buffer_pool_size: 96GB<\/p>\n

max_connections: 2000<\/p>\n

innodb_flush_log_at_trx_commit: 1<\/p>\n

sync_binlog: 1<\/p>\n

\n

\"\"<\/p>\n

<\/div>\n<\/div>\n

2. Installing sysbench<\/h2>\n

(1)\u00a0Quick install instructions<\/h3>\n
yum -y install sysbench\n\nsysbench --version\u00a0 \u00a0 #sysbench 1.0.9<\/pre>\n
(2) Building and Installing From Source<\/h3>\n
We can also download sysbench package on the Github(https:\/\/github.com\/akopytov\/sysbench<\/a>), and the\u00a0README.md<\/strong> there shows how to install and use it.<\/p>\n
3.\u00a0File IO Benchmark<\/h2>\n
(1)Create files<\/h3>\n
To avoid the RAM\u00a0tampers the benchmark result, we should create files bigger than the RAM size. So i create 150GB files at the data directory:<\/p>\n
cd \/data1\n\nsysbench --test=fileio --file-total-size=500G prepare<\/pre>\n
This command will create a\u00a0total of 500GB of files(default: 128 files)<\/p>\n
To avoid the influence of RAM caching, we need to set ‘–file-total-size<\/strong>‘\u00a0to be larger\u00a0than RAM.<\/p>\n
(2)IO benchmark<\/h3>\n
sysbench --test=fileio --file-total-size=500G --file-test-mode=rndrw --init-rng=on --max-time=300 --max-requests=0 run<\/pre>\n
Result:<\/span><\/p>\n
File operations:\n\n\u00a0 \u00a0 reads\/s:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 16121.01\n\n\u00a0 \u00a0 writes\/s:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 10747.29\n\n\u00a0 \u00a0 fsyncs\/s:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 34390.58\n\nThroughput:\n\n\u00a0 \u00a0 read, MiB\/s:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 251.89\n\n\u00a0 \u00a0 written, MiB\/s:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 167.93\n\nGeneral statistics:\n\n\u00a0 \u00a0 total time:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 300.0049s\n\n\u00a0 \u00a0 total number of events:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 18378137\n\nLatency (ms):\n\n\u00a0 \u00a0 \u00a0 \u00a0 min:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 0.00\n\n\u00a0 \u00a0 \u00a0 \u00a0 avg:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.04\n\n\u00a0 \u00a0 \u00a0 \u00a0 max:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 22.06\n\n\u00a0 \u00a0 \u00a0 \u00a0 95th percentile:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4.10\n\n\u00a0 \u00a0 \u00a0 \u00a0 sum:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 19163038.42\n\nThreads fairness:\n\n\u00a0 \u00a0 events (avg\/stddev):\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 287158.3906\/763.93\n\n\u00a0 \u00a0 execution time (avg\/stddev):\u00a0 299.4225\/0.01<\/pre>\n
The result shows that\u00a016121.01 reads\/s,\u00a010747.29 writes\/s, and\u00a0251.89\u00a0MiB\/s for reading,\u00a0167.93 for writing.<\/p>\n
4.\u00a0MySQL OLTP(On-Line Transaction Processing) Benchmark<\/h2>\n
(1)Prepare tables and rows<\/h3>\n
sysbench \/usr\/share\/sysbench\/oltp_read_write.lua --mysql-host=10.1.0.20 --mysql-port=5701 --mysql-user=sbtest --mysql-password='sbtestpwd' --mysql-db=sbtest --db-driver=mysql --tables=3 --table-size=10000000\u00a0 prepare<\/pre>\n
This command means that creating 3 tables,\u00a0and each table contains 10 million rows.<\/p>\n
\"\"<\/div>\n
<\/h3>\n
(2)Run\u00a0benchmark<\/h3>\n
There are many LUA scripts in the \/usr\/share\/sysbench<\/strong>\u00a0directory, and you can choose a suitable one to have the benchmark.<\/p>\n
\"\"<\/p>\n
<\/div>\n
sysbench \/usr\/share\/sysbench\/oltp_read_write.lua --mysql-host=10.1.0.20 --mysql-port=5701 --mysql-user=sbtest --mysql-password='sbtestpwd' --mysql-db=sbtest --db-driver=mysql --tables=3 --table-size=10000000 --report-interval=10 --threads=128 --time=600 run 2>&1<\/pre>\n
Number of threads: 128<\/strong><\/p>\n
Report intermediate results every 10 second(s)<\/strong><\/p>\n
Running time: 600 seconds<\/strong><\/p>\n
While running sysbench, we can check some status. Look at the top status, the mysqld process uses almost 48 cores of CPU and 14% of memory(about 18 GB).<\/p>\n
\n
\"\"<\/p>\n
\n
top status<\/pre>\n<\/div>\n<\/div>\n
\n
\"\"<\/p>\n
<\/div>\n
memory usage<\/div>\n<\/div>\n
<\/div>\n
We can get the report information as below(–report-interval=10 :periodically report intermediate statistics with a specified interval in seconds<\/strong>):<\/div>\n
\n
\"\"<\/p>\n
<\/div>\n<\/div>\n
\n
\"\"<\/p>\n
<\/div>\n<\/div>\n
You can get the TPS(18183.90)\/QPS(363684.99), total transactions, total queries(including read and write), how many errors\u00a0happened from the report. Also you can find the\u00a0latency metrics(95%: 10.65 ms) and the query\u00a0distribution.<\/p>\n
If you write a lot, then you can increase the INSERT\/UPDATE\/DELDETE queries per transaction, then set different number of queries per transaction, depend on the usage cases. For example,<\/p>\n
sysbench \/usr\/share\/sysbench\/oltp_read_write.lua --mysql-host=10.1.0.20 --mysql-port=5701 --mysql-user=sbtest --mysql-password='sbtestpwd' --mysql-db=sbtest --db-driver=mysql --tables=3 --table-size=10000000\u00a0--delete_inserts=10 --index_updates=10 --non_index_updates=10\u00a0--report-interval=10 --threads=128 --time=600 run<\/pre>\n
The report shows that there are more writes per transaction.<\/p>\n
\n
\"\"<\/p>\n
<\/div>\n<\/div>\n
Get more information by:<\/p>\n
sysbench \/usr\/share\/sysbench\/oltp_read_write.lua help<\/pre>\n
Then we can\u00a0roughly estimate if this system and MySQL instance is enough for our usage, it must be much better than our needs, because the queries are more complicated at the production environment, and these queries require more system resources to execute.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the\u00a0maximal QPS(Query Per Second), concurrent threads and so on. Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":50,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[7],"tags":[1502,1301,1503],"class_list":["post-3138","post","type-post","status-publish","format-standard","","category-mysql","tag-benchmark","tag-mysql","tag-sysbench"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":7424,"today_views":0},"yoast_head":"\nBenchmark performance of MySQL using SysBench - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Benchmark performance of MySQL using SysBench - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-21T08:36:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-11T07:15:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png\" \/>\n<meta name=\"author\" content=\"Shuo Wang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shuo Wang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\"},\"author\":{\"name\":\"Shuo Wang\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\"},\"headline\":\"Benchmark performance of MySQL using SysBench\",\"datePublished\":\"2018-09-21T08:36:29+00:00\",\"dateModified\":\"2019-04-11T07:15:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\"},\"wordCount\":444,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png\",\"keywords\":[\"benchmark\",\"MySQL\",\"sysbench\"],\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\",\"name\":\"Benchmark performance of MySQL using SysBench - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png\",\"datePublished\":\"2018-09-21T08:36:29+00:00\",\"dateModified\":\"2019-04-11T07:15:01+00:00\",\"description\":\"Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png\",\"width\":652,\"height\":117},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Benchmark performance of MySQL using SysBench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\",\"name\":\"Shuo Wang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"caption\":\"Shuo Wang\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/shuowang\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Benchmark performance of MySQL using SysBench - Database Tutorials","description":"Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.","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:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/","og_locale":"en_US","og_type":"article","og_title":"Benchmark performance of MySQL using SysBench - Database Tutorials","og_description":"Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/","og_site_name":"Database Tutorials","article_published_time":"2018-09-21T08:36:29+00:00","article_modified_time":"2019-04-11T07:15:01+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png","type":"","width":"","height":""}],"author":"Shuo Wang","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shuo Wang","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/"},"author":{"name":"Shuo Wang","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289"},"headline":"Benchmark performance of MySQL using SysBench","datePublished":"2018-09-21T08:36:29+00:00","dateModified":"2019-04-11T07:15:01+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/"},"wordCount":444,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png","keywords":["benchmark","MySQL","sysbench"],"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/","url":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/","name":"Benchmark performance of MySQL using SysBench - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png","datePublished":"2018-09-21T08:36:29+00:00","dateModified":"2019-04-11T07:15:01+00:00","description":"Sysbench is a benchmark tool, it can be used to benchmark many items including the system and database. This article will introduce how to benchmark MySQL and disk IO performance.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/pic1.png","width":652,"height":117},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/21\/benchmark-performance-of-mysql-using-sysbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Benchmark performance of MySQL using SysBench"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289","name":"Shuo Wang","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","caption":"Shuo Wang"},"url":"https:\/\/dbtut.com\/index.php\/author\/shuowang\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=3138"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3138\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}