cancel
Showing results for 
Search instead for 
Did you mean: 

slow performance of the server

 
SOLVED
Go to solution
Highlighted
Trusted Contributor

slow performance of the server

Hello all,

Recently we deployed an appln on PROD server after testing it on test server.
It is a web based timesheet appln which has a mysql database hosted on Linux server.

After we were satisfied with the testing of appln and database we migrated it to PROD. But the appln has been behaving weird.

The data fetching is very slow on the PROD server. we also tested the appln/DB on dev server. The performance was acceptable.

I have attached some statistics to compare all 3 servers.

After looking at many things i am not able to point to something for the slow response on PROD server. There are many differentiating points among the 3 machines; but which one is most responsible for slow response is still a mystery to me.

Can you guide me through this

Sunny





14 REPLIES 14
Highlighted
Honored Contributor

Re: slow performance of the server

Hello,

From your sheet, I can understand that your prod is the oldest machine from all. You should upgrade at least your OS.

What is the output of

cat /proc/cpuinfo

for all those systems?

Horia.
Best regards from Romania,
Horia.
Highlighted
Trusted Contributor

Re: slow performance of the server

cpuinfo attached.
Yes, PROD is the oldest.
My last resort would be to upgrade the OS, may also get a new server completely.

However, i want to try all possible things before that
Highlighted
Honored Contributor

Re: slow performance of the server

Change the installed HDD (maybe also another SCSI controller ? - you have to check specs) with a better transfer rate in order to improve I/O latency, then upgrade the OS.

Horia.
Best regards from Romania,
Horia.
Highlighted
Trusted Contributor

Re: slow performance of the server

Please note that all the servers have internal disks with capacity 75G, 160G, 250, etc.
Highlighted
Honored Contributor

Re: slow performance of the server

I see now, all have U320 SCSI 10k HDD.

How about installed memory/swap size?

You should upgrade the OS.

Horia.
Best regards from Romania,
Horia.
Highlighted
Honored Contributor

Re: slow performance of the server

You could leave the application on the test server until you will be able to upgrade the server/get another one.

Horia.
Best regards from Romania,
Horia.
Highlighted
Trusted Contributor

Re: slow performance of the server

PROD server has 6GB RAM and 4GB SWAP
I guess that is enough physical memory.

I had a doubt if i need to keep the physmem and swap equal or double but people recommended to keep it as it is as physical mem is enough so that swap would be hardly be used.
Highlighted
Honored Contributor

Re: slow performance of the server

I would increase the swap in this case.

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1344830

Do you ever get core dumps with out of memory messages?

Does not hurt to make it 6G swap. If your HDD space is not a premium, you should consider it making swap bigger: 10-12G maybe?. Always use dedicated partitions for swap.

Horia.
Best regards from Romania,
Horia.
Highlighted
Trusted Contributor

Re: slow performance of the server

yes... i would definitely increase the swap to 6GB atleast.

But increasing the swap won't solve the problem at hand. Because the appln is not memory intensive and i have sufficient phy mem to suffice the appl needs.

I have 2 options
1. Change the HDD and scsi controller which has better throughput
2. Update the OS


Are there more options before i change h/w or s/w

Can it be a problem with device drivers??