Question

prometherion on Mon, 05 Jun 2017 12:26:19


I was benchmarking Azure MySQL with sysbench (OLTP) and the results are not so good due to high response time, as following.

    response time:
         min:                                 28.53ms
         avg:                                 42.63ms
         max:                                319.59ms
         approx.  95 percentile:              52.40ms

I noticed that Azure MySQL cannot connect to a Virtual Network (VLAN): there will be a solution to this problem, maybe the VLAN join?

Sponsored



Replies

Hong Wang – MSFT on Mon, 05 Jun 2017 16:29:26


Can you share the test configuration you are using, and the baseline server configuration (I assume you use the Azure VM + MySQL as baseline) you use for? 

Azure MySQL don't support VNET today, but it is in the roadmap.

prometherion on Tue, 06 Jun 2017 06:46:41


I run the test twice, first one inside a Mesosphere DC/OS Cluster made of Standard D2 VM scale set, second one from the master (Standard D2) to Azure MySQL. Obviously the scale set instances are bounded within a virtual network created by the ACS template.

The results of a MySQL inside the cluster are following:

    response time:
         min:                                  9.03ms
         avg:                                 21.21ms
         max:                                219.37ms
         approx.  95 percentile:              32.70ms

The test configuration is the default one offered by sysbench (OLTP), except for number of threads (8), row size (1,000,000) and read-only mode: I used this docker image in order to avoid test inconsistency (https://hub.docker.com/r/carsonoid/sysbench/).

Hong Wang – MSFT on Thu, 15 Jun 2017 15:13:42


Hi,

I am sorry for missing your reply. Although I don't think the VLAN is the key factor of the slower response time. We will double check and back to you ASAP.

Hong