{"id":33,"date":"2019-07-15T16:20:19","date_gmt":"2019-07-15T16:20:19","guid":{"rendered":"http:\/\/dynimize.com\/blog\/?p=33"},"modified":"2021-02-08T23:37:20","modified_gmt":"2021-02-08T23:37:20","slug":"dynimize-quickstart-tutorial","status":"publish","type":"post","link":"https:\/\/dynimize.com\/blog\/tutorials\/beginner\/dynimize-quickstart-tutorial\/","title":{"rendered":"Dynimize Quickstart Tutorial"},"content":{"rendered":"

Duration: <\/em><\/strong>10 min<\/em><\/span><\/p>\n

Level: <\/strong>Beginner<\/em><\/span><\/p>\n

 <\/p>\n

This tutorial will show you how to install Dynimize. We'll then use it to optimize a live MySQL process that's been running the Sysbench OLTP benchmark, obtaining a 46% increase in performance by applying Dynimize<\/strong>.<\/p>\n

 <\/p>\n

Part 1:  Quickstart<\/h2>\n

 <\/p>\n

Here's a quick overview of how to use Dynimize.<\/p>\n

To install Dynimize, run the following commands.<\/p>\n

wget https:\/\/dynimize.com\/install -O install
\nwget https:\/\/dynimizecloud.com\/install.sha256 -O install.sha256
\nsha256sum -c install.sha256; if [ $? -eq 0 ]; then sudo bash .\/install -d; fi<\/div>\n

 <\/p>\n

Use your access token<\/a> to start a subscription license for your host.<\/p>\n

$ sudo dyni -license=start -token=<your-access-token><\/div>\n

 <\/p>\n

To start Dynimize, run<\/p>\n

$ sudo dyni -start<\/div>\n

 <\/p>\n

To check the status of Dynimize and any optimization targets, run:<\/p>\n

$ sudo dyni -status<\/div>\n

 <\/p>\n

Once a target process has been fully optimized, the above command will report:<\/p>\n

\nDynimize is running
\nmysqld, pid: 21091, dynimized
\n<\/div>\n

 <\/p>\n

It could take anywhere from 30 to 300s of CPU intensive activity from the target process before Dynimize has completed profiling and optimizing that process.<\/p>\n

Deciding which applications to target can be done by editing the list of supported target exes in \/etc\/dyni.conf under the [exeList] section.<\/p>\n

 <\/p>\n

To stop Dynimize, run:<\/p>\n

$ sudo dyni -stop<\/div>\n

 <\/p>\n

To stop the subscription license for this host, run:<\/p>\n

$sudo dyni -license=stop -token=<your-access-token><\/span><\/div>\n

 <\/h4>\n

Follow this tutorial<\/a> for help measuring the performance impact.<\/p>\n

 <\/p>\n

Part 2:   Benchmarking with Dynimize<\/h2>\n

 <\/p>\n

In the remainder of this tutorial we'll demonstrate how to benchmark MySQL using the Sysbench OLTP benchmark, and then improve on the benchmark results by installing and running Dynimize alongside MySQL. We try to keep things as simple as possible, and so by no means is this meant to demonstrate the most realistic or optimal way to benchmark MySQL with Sysbench, or accurately measure the improvements Dynimize can achieve. This tutorial can be completed with any version of MySQL, MariaDB, or Percona Server, and it is assumed that one of these is already installed.<\/p>\n

Note that the benchmark is run using a CPU bound setup, with --oltp-read-only=on so that the IO subsystem is not involved, and making sure the workload fits into RAM. This example was run on a cloud based VPS from OVH, with 2 vCPUs (2.4 Ghz Haswell), with 8 GB ram, and a 40 GB SSD. You can recreate this exact VM on OVH's public cloud<\/a> by selecting the VPS-SSD-3 server option in their Beauharnois data center. We used Ubuntu 16.04.2 LTS with MySQL 5.7.18, and Sysbench 0.4.12. Note that Sysbench 0.4 is used in this tutorial because it can easily be installed from most Linux repositories. Note that Dynimize speedups can be more pronounced when running on KVM hypervisors, as is the case here.<\/p>\n

 <\/p>\n

1. Install Sysbench<\/strong><\/p>\n

apt-get based install:<\/p>\n

$ sudo apt-get install sysbench<\/div>\n

 <\/p>\n

OR<\/p>\n

yum based install:<\/p>\n

$ sudo yum install sysbench<\/div>\n

 <\/p>\n

2. Run sysbench<\/strong><\/p>\n

In the following commands, make sure to replace user and password with something appropriate. Here we use the database name testDB.<\/p>\n

Lets start off with a fresh MySQL process:<\/p>\n

$ sudo service mysql restart<\/div>\n

 <\/p>\n

Load a table for the Sysbench OLTP workload. Make sure to replace user and password as appropriate:<\/p>\n

\n$ mysql -u user --password=password -e \"DROP DATABASE testDB;\"
\n$ mysql -u user --password=password -e \"CREATE DATABASE testDB;\"
\n$ sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=testDB --mysql-user=user --mysql-password='password' prepare
\n<\/div>\n

 <\/p>\n

Perform a warm-up run:<\/p>\n

\n$ sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=testDB --mysql-user=user --mysql-password='password' --max-time=120 --oltp-read-only=on --max-requests=0 --num-threads=8 run
\n<\/div>\n

 <\/p>\n

Perform a measurement run (command is the same as warm-up):<\/p>\n

\n$ sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=testDB --mysql-user=user --mysql-password='password' --max-time=120 --oltp-read-only=on --max-requests=0 --num-threads=8 run
\n<\/div>\n

 <\/p>\n

These runs will produce results in the following format:
\n

OLTP test statistics:
\nqueries performed:
\nread: 1203062
\nwrite: 0
\nother: 171866
\ntotal: 1374928
\ntransactions: 85933 (1432.12<\/b> per sec.)
\ndeadlocks: 0 (0.00 per sec.)
\nread\/write requests: 1203062 (20049.73 per sec.)
\nother operations: 171866 (2864.25 per sec.)
\n
Test execution summary:
\ntotal time: 60.0039s
\ntotal number of events: 85933
\ntotal time taken by event execution: 479.6911
\nper-request statistics:
\nmin: 1.19ms
\navg: 5.58ms
\nmax: 41.07ms
\napprox. 95 percentile: 7.85ms
\n
Threads fairness:
\nevents (avg\/stddev): 10741.6250\/233.97
\nexecution time (avg\/stddev): 59.9614\/0.00<\/div>\n

 <\/p>\n

In this case we can see transactions per second of 1432.12<\/strong> as highlighted above.<\/p>\n

 <\/p>\n

3. Repeat with Dynimize<\/strong><\/p>\n

Let's repeat that with Dynimize running. First install Dynimize and start a host license if you haven't already.<\/p>\n

If you haven't already done so, install Dynimize:<\/p>\n

wget https:\/\/dynimize.com\/install -O install
\nwget https:\/\/dynimizecloud.com\/install.sha256 -O install.sha256
\nsha256sum -c install.sha256; if [ $? -eq 0 ]; then sudo bash .\/install -d; fi<\/div>\n

 <\/p>\n

If you haven't already started a subscription license for your host then use your access token<\/a> to start one :<\/p>\n

$sudo dyni -license=start -token=<your-access-token><\/span><\/div>\n

 <\/p>\n

Now start Dynimize:<\/p>\n

$ sudo dyni -start<\/div>\n

 <\/p>\n

Perform another warmup run to get the mysqld process in the \"dynimized\" state:<\/p>\n

$ sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=testDB --mysql-user=user --mysql-password='password' --max-time=120 --oltp-read-only=on --max-requests=0 --num-threads=8 run<\/div>\n

 <\/p>\n

After the warmup make sure mysqld is dynimized:<\/p>\n

$ sudo dyni -status
\nDynimize is running
\nmysqld, pid: 25072, dynimized<\/div>\n

 <\/p>\n

If the mysqld process is not yet dynimized then repeatedly run the warm-up followed by sudo dyni -status until mysqld shows up as dynimized.<\/p>\n

 <\/p>\n

Now that mysqld is dynimized, let's measure its performance again:<\/p>\n

$ sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=testDB --mysql-user=user --mysql-password='password' --max-time=120 --oltp-read-only=on --max-requests=0 --num-threads=8 run<\/div>\n

 <\/p>\n

Which will output the following:<\/p>\n

OLTP test statistics:
\nqueries performed:
\nread: 1759352
\nwrite: 0
\nother: 251336
\ntotal: 2010688
\ntransactions: 125668 (2094.36<\/strong> per sec.)
\ndeadlocks: 0 (0.00 per sec.)
\nread\/write requests: 1759352 (29321.06 per sec.)
\nother operations: 251336 (4188.72 per sec.)
\n
Test execution summary:
\ntotal time: 60.0030s
\ntotal number of events: 125668
\ntotal time taken by event execution: 479.5530
\nper-request statistics:
\nmin: 0.77ms
\navg: 3.82ms
\nmax: 492.75ms
\napprox. 95 percentile: 5.52ms
\n
Threads fairness:
\nevents (avg\/stddev): 15708.5000\/166.91
\nexecution time (avg\/stddev): 59.9441\/0.00<\/div>\n

 <\/p>\n

Here we see transactions per second of 2094.36<\/strong>, which is a 46% speedup<\/strong> from the baseline of 1432.12<\/strong> tps.<\/p>\n

That concludes this tutorial. Happy Dynimizing!<\/p>\n","protected":false},"excerpt":{"rendered":"

Duration: 10 min Level: Beginner   This tutorial will show you how to install Dynimize. We'll then use it to optimize a live MySQL process that's been running the Sysbench OLTP benchmark, obtaining a 46% increase in performance by applying Dynimize.   Part 1:  Quickstart   Here's a quick overview of how to use Dynimize. To install Dynimize, run the following commands. wget https:\/\/dynimize.com\/install -O install wget https:\/\/dynimizecloud.com\/install.sha256 -O install.sha256 sha256sum -c install.sha256; if [ $? -eq 0 ]; then sudo bash .\/install -d; fi   Use your access token to start a subscription license for your host. $ sudo dyni -license=start -token=<your-access-token>   To start Dynimize, run $ sudo dyni -start   To check the status of Dynimize and any optimization targets, run: $ sudo dyni -status   Once a target process has been fully optimized, the above command will report: Dynimize is running mysqld, pid: 21091, dynimized   It could take anywhere from 30 to 300s of CPU intensive activity from the target process before Dynimize has completed profiling and optimizing that process. Deciding which applications to target can be done by editing the list of supported target exes in \/etc\/dyni.conf under the [exeList] section.   To stop Dynimize, run: $ sudo dyni -stop   To stop the subscription license for this host, run: $sudo dyni -license=stop -token=<your-access-token>   Follow this tutorial for help measuring the performance impact.   Part 2:   Benchmarking with Dynimize   In the remainder of this tutorial we'll demonstrate how to benchmark MySQL using the Sysbench OLTP benchmark, and then improve on the benchmark results by installing and running Dynimize alongside MySQL. We try to keep things as simple as possible, and so by no means is this meant to demonstrate the most realistic or optimal way to benchmark MySQL with Sysbench, or... <\/p>\n

Continue Reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":6066,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[45,59,47,63,46],"class_list":["post-33","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-beginner","tag-dynimize","tag-kvm","tag-mysql","tag-performance","tag-sysbench"],"_links":{"self":[{"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/posts\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":124,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":6690,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/posts\/33\/revisions\/6690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/media\/6066"}],"wp:attachment":[{"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynimize.com\/blog\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}