slow performance of the server

[Sunny Jaisinghani]

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

[Horia Chirculescu]

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.

[Sunny Jaisinghani]

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

[Horia Chirculescu]

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.

[Sunny Jaisinghani]

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

[Horia Chirculescu]

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

How about installed memory/swap size?

You should upgrade the OS.

Horia.

[Horia Chirculescu]

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

Horia.

[Sunny Jaisinghani]

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.

[Horia Chirculescu]

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.

[Sunny Jaisinghani]

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??