Having too many connections could affect performance ?

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Having too many connections could affect performance ?
# 1  
Old 02-08-2017
Having too many connections could affect performance ?

Good evening, i need your help please

I will try to describe the scenario briefly: In a Telecom Production system application receives a certain files called CDRs(call detail records) to be processed by doing some operating systems operations and then database operations like creating indexes and uploading to a Central Database-

The applications server and database is quite obsolete OSF1 and oracle 9i.

Many times the applications turn very slow to process so performance is overheated. Of course There would be many causes for overheated performance, and it is premature to identify the problem at first glance.

So Could you tell me if below theories could affect Performance ?
  1. I run netstat command and displays more than 102 connections some of them established state, some of them time wait, etc. So the question is having many connections could affect the performance of the application?
    If I killed and restart connections would be a good idea to improve performance?
  2. Having one or more Filesystem backups could affect Performance too ?

I appreciate your answers in advanced or if u have any other reason that could impact its performance let me know. Thanks

Last edited by rbatte1; 02-09-2017 at 05:19 AM.. Reason: Converted textual list to formatted numbered list and corrected spellings
# 2  
Old 02-09-2017
With what you have told us, the application could be a huge bottleneck, the application server could be a huge bottleneck, the database server could be a huge bottleneck, the database application could be a huge bottleneck, or any combination of the above could be a bottleneck.

Running a filesystem backup while running applications that are using files on that filesystem is VERY likely to affect performance of those applications and of the backup software.

We have seen examples in this forum of text processing code that invokes several processes to produce output for each line read from a file containing a few thousand lines that literally ran for more than 10 hours. When that code was replaced by a single awk script with the output fed into sort, the script ran in less than 10 seconds and produced exactly the same output. Could your application code have a similar issues?

To figure out where you need to look, you first need to know what are your major stumbling blocks. Are you swapping processes in and out a lot? (Need more memory?) Are your disks thrashing? (Put files on different filesystems on different disks/controllers?) Are your CPUs running at 100%? (Badly written code or too many users on your system?) Is your network dropping packets? (Loose connections, faulty routes to servers, failing hardware, etc.?) ... ... ...
# 3  
Old 02-11-2017
Thanks you very much for your Analisis and contribution to my concerns. but what do you mean when you say your major stumbling blocks ? i didnt get it.

---------- Post updated at 06:40 PM ---------- Previous update was at 06:18 PM ----------

sorry i know what you meant, i ve got it. thanks

---------- Post updated at 06:53 PM ---------- Previous update was at 06:40 PM ----------

which administrative commands can i use besides top for finding the stumbling blocks you mention and taking account the OS is obsolete ?

Thanks for your help
# 4  
Old 02-12-2017
Quote:
Originally Posted by alexcol
So Could you tell me if below theories could affect Performance ?
  1. I run netstat command and displays more than 102 connections some of them established state, some of them time wait, etc. So the question is having many connections could affect the performance of the application?
    If I killed and restart connections would be a good idea to improve performance?
  2. Having one or more Filesystem backups could affect Performance too ?
Many network connections might affect performance, but right now it isn't even established if you have "many" of them. Connections in the stated of "TIME_WAITING" will not contribute to the load at all and your suggested solution of killing and restarting connections would definitely not help at all.

Running filesystem backups could very well degrade performance but if that is the case or not we can't say.

Quote:
Originally Posted by alexcol
T
which administrative commands can i use besides top for finding the stumbling blocks you mention and taking account the OS is obsolete ?
You might want to read this little introduction to performance tuning i wrote. Most of the tools mentioned there should work for you and most of the concepts explained there should apply to your server.

I hope this helps.

bakunin
# 5  
Old 02-13-2017
For OSF1 I found this resource
You might want to tune the following
Quote:
somaxconn=1024
tcbhashsize=1024
maxuprc=256
But it takes memory. You should have 2GB RAM at least.

Last edited by MadeInGermany; 02-13-2017 at 05:45 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script affect load average

Hello I have created next scritpt to do the next: chekp if host is alive. When the host down, launch telnet other equip to do checks. When execute the script the load average of the machines increase. For example: Before launch script top - 11:14:56 up 14 days, 18:06, 3 users, load... (3 Replies)
Discussion started by: capilla
3 Replies

2. Shell Programming and Scripting

affect a exploded a string into an array

I would like to affect an exploded string into an array. one:two::fourinto an array: a => one a => two a => a => four Quite simple in other languages with functions like explode() or split(). The best I could come up with was this: until do token=${string%%:*} # takes the... (8 Replies)
Discussion started by: ripat
8 Replies

3. Solaris

Will creating symbolic links affect users

Hi, I have a quick question with regards to creating symbolic links. Would creating a symbolic link from one directory to a file in another cause any issues for users that are currently logged into the box. I don't believe it will unless they are using the file in question, but I would like... (2 Replies)
Discussion started by: Chains
2 Replies

4. UNIX for Dummies Questions & Answers

.profile - changes don't affect the login

I have modified the .profile in my profile and I don't see any effect. Why the changes don't have effect? I tried both on the account at a server where I have limited permissions as user and to my local pc (as user). Is it the .profile overridden by some other file? It looks weird because I... (8 Replies)
Discussion started by: myle
8 Replies

5. Solaris

Will Password change affect authorized_keys?

Hello gurus, I have question. I have enabled ssh on the servers. I am planning to change the oracle user's(os user) password. If I change the password will it affect the authorized_keys? Do I need to regenerate it. Thanks, (2 Replies)
Discussion started by: oracleuser
2 Replies

6. Shell Programming and Scripting

affect variable

hi , i want to store variable but i get always error when i excute this command ligne : var = awk '{print $1}' file1 echo $var how can i store the var? thanks (7 Replies)
Discussion started by: kamel.seg
7 Replies

7. Solaris

making new default gateway take affect

How do you make the changes take affect when you change the subnet masks or default router without rebooting? (1 Reply)
Discussion started by: BG_JrAdmin
1 Replies

8. UNIX for Advanced & Expert Users

changig uid and the affect it will have

Hello, I have 2 sun servers. We are running Oracle apps. We have to apply patches to both servers whenever a patch needs to be applied for Oracle. We use the same username eg. applmgr on both servers. We have a shared patch area which we can run the patch from on both boxes. the uid for... (2 Replies)
Discussion started by: d__browne
2 Replies
Login or Register to Ask a Question