MySQL Forums
Forum List  »  Performance

Slow performance over network
Posted by: Will Duckworth
Date: May 30, 2013 03:45AM

Overview
Tomcat application version: 5.5.20 with server IBM x3550 M2 with 8GB RAM Xeon X5570 2.93GHz running SLES 11 SP0
MySQL 5.1 on IBM x3650 M2 96GB RAM Xeon X5570 2.93GHz running SLES 11 SP0

Migrated for hardware upgrades for MySQL servers and virtualizing the application servers:
Tomcat application same versions VM 8GB RAM 8xvCPU Xeon 2.6GHz running SLES 11 SP2
MySQL physical servers IBM x3650 192 GB RAM 2x8Core Xeon E5-2670 2.6GHz running SLES 11 SP2
Both backed by SAN storage (IBM v7000) with 8GB fibre

Challenge:
The new server estate running significantly slower than the original setup – ‘bad performance’, mostly slow connect times - 40-400 ms (instead of less than 1 ms)

Tried so far:
Multiple MySQL and OS configuration parameters (support calls open with Oracle and Novell)
We have tried rolling back the OSs to SLES SP0 and SP1 to no effect
Virtualizing MySQL
Running MySQL on similarly ‘old’ M2 class hardware

A test we ran which had ‘good performance’ was when we put the application on the MySQL server and using ‘localhost’ in the connection strings (to bypass networking)

current params set to cut out the DNS are:
skip-name-resolve
skip-host-cache


any ideas much appreciated, i appreciate the versions of mysql and tomcat etc are old - but thats the app unfortunately!

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow performance over network
2545
May 30, 2013 03:45AM


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.