Performance issues after migrating to a new server with better hardware config

[Guddu Gupta]

Hello,
I need help optimizing a server. We are currently using a pc with below configuration as a server (current) for Sugarcrm.

Processor: i7-4770K
RAM: 16GB
Hard disk: SATA 500GB 7200 rpm
OS: Ubuntu 12.04 LTS
SugarCRM version: 6.5.10 CE
DB: mysql
DB size: Around 5 GB

Since the number of users were increasing we thought of migrating to a server (new) based hardware with below configuration

Processor: Xeon E5-2630v3 8 core x 2
RAM: 16 GB DDR4
Hard disk: SAS 1 TB Raid
OS: Ubuntu 14.04 LTS
SugarCRM version: 6.5.10 CE
DB: mysql
DB size: Same as above

Surprisingly, the same lead takes about 4.5 seconds to open on current i7 pc but takes about 12 seconds on the xeon server. The xeon server currently does not have any users connected to it as we are unable to resolve the issues related to performance.

We even tried taking a clone of the current server but didn't help.

We've spent about 20 days trying to optimize it but are still unable to do the same. Could anyone please suggest how we can identify what the bottleneck might be.

I'm attaching a top command screen shot for reference.

Any help would be greatly appreciated. Thanks in advance.

 

[unixfish]

My guess is it's database tuning. It is never straight forward, and "the same configuration" may not work from machine to machine.

Before you do anything else, optimize all your tables in the database. This will reset the index files and clean up fragmentation, etc. This is usually a good start.

Google MySQL database tuning to start; there is also mysqltuner.pl which will analyze the database and make suggestions on how to set up parameters. Make sure you run a "bunch of stuff" against the new database first so you can get some run-time metrics to analyze. If you can't, analyzing a static database will still get you a baseline to work with.

This should get you in the ballpark. If not, check back and someone who is a bit heavier on DBA tasks should be able to help.

 

[Guddu Gupta]

Thanks unixfish. I agree. It feeling like a tuning issue. Just the thing is we are not able to do it.

I tried the mysqltuner.pl and made the changes it suggested for performance. There were not too many performance related suggestions though. But alas, still no improvement.

Just for your information, we tried one more thing. We tried putting this same hard disk in current i7 machine. It works fast there. But when connected to this xeon server, it slows down.

 

[VitalkaDrug]

We are currently using a pc with below configuration as a server (current) for Sugarcrm.

Processor:
RAM: 16GB
Hard disk: SATA 500GB 7200 rpm
OS: Ubuntu 12.04 LTS
SugarCRM version: 6.5.10 CE
DB: mysql
DB size: Around 5 GB

What CPU do you use in the current server?
Did you compare a CPU frequency for both servers?

 

[Guddu Gupta]

What CPU do you use in the current server?
Did you compare a CPU frequency for both servers?

Sorry the details about our current CPU got missed out.

Current CPU: i7-4770K
Base frequency: 3.5 GHz

New CPU: Xeon E5-2630v3
Base frequency: 2.4 GHz

Do you think this could be a reason?

 

[VitalkaDrug]

Current CPU: i7-4770K
Base frequency: 3.5 GHz

New CPU: Xeon E5-2630v3
Base frequency: 2.4 GHz

Do you think this could be a reason?

I think it may be critical.
The frequency of the current server over a third greater than the frequency of the new.
As I can see the main load is going to your CPU, not to the disk subsystem.
So, changing to a weaker CPU is not a right choice.
Possibly you have to adjust your MySQL settings or optimize your data.