MySQL Forums
Forum List  »  Performance

Re: Performance over Leased Line 10 Mbit
Posted by: Dimitri Kravtchuk
Date: March 28, 2013 10:51AM

Peter,

there is a big difference between throughput and latency bound workloads.. - so, you have to analyze it first for your workload. Because if you're a lot latency dependent, you may create a full disaster for your users. As well don't base on the "ping" latency, it's quite different from a "normal" network usage. Don't know if tested Sysbench workload is really representative for your users, but as it's doing small+fast OLTP queries, it's pretty speaking for a network.. - and from response time looks like "remote" server is x60 times worse (and it's not 1ms to 15ms ratio as you see).. So, imagine now if your "application transaction" is combined of many such fast queries printing you a final page within 1sec.. -- with your bigger latency you may wait for a page more than 1min then.. which will be very visible and blaming ;-))

so, my advise: if you have a time to investigate, try to setup some simulators of network conditions (I remember we used some kind of such SW in the past to simulate very far remote location (or just buy you several km of network cable and plug very old switches between nodes ;-)) -- then at least you'll know what to expect very quickly ;-))

otherwise: don't touch it and you'll sleep well ;-)

Rgds,
-Dimitri

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Performance over Leased Line 10 Mbit
894
March 28, 2013 10:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.