Network related issues Post: 303002968

Sponsored Content

Homework and Emergencies Emergency UNIX and Linux Support Network related issues Post 303002968 by rbatte1 on Wednesday 6th of September 2017 05:33:29 AM

09-06-2017

Moderator

Some wild guesses:-

Loss of access to DNS server (slow reverse IP lookup for auditing, so slow login or application)
Database locks - hugely dependant on your application
Missing database index causing full table scans
Poor data queries, e.g. get all records from the database then check each in turn on criteria rather than building the condition into the query
Database logs files filling and flushing too slowly
Exhausting real memory causing paging (potentially DB consuming too much real memory)
Network speed conflict, e.g. if NIC is 10M-half and switch is 100M-full, it will work, but any file transfer will cripple it with lots of dropped packets.
IO issues, especially with NFS or an HA cluster if you fail over
Scheduled work, e.g. current stock summary
Ad-hoc jobs, e.g. current stock summary
Resources stealing by another LPAR if the definitions allow it
Large write volume to direct disk (e.g. local) rather than cached disk (RAID or SAN etc.)
High NFS contention especially with other seemingly unrelated servers

You can see it is a very very VERY wide spread of options so far - and the list is a long way from being exhaustive. You need to be a fair bit more explicit about what you have (including OS) what goes slow, what's happening at the time, what dependencies you have with other servers.

Robin

rbatte1

View Public Profile for rbatte1

Visit rbatte1's homepage!

Find all posts by rbatte1

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Network printer issues

Hello, I have been having a problem with printing to a network printer on my LAN, I am able to ping all ports from the server and the printer. Print request just stay in the print que the only way to print is from the parallel line to the server. Any ideas on what can be going wrong?? Lp sched is...

2. Solaris

Solaris 10 network, process, database related comands

Hi everbody, Can anyone let me know the resources for list of network, process, database related commands of solaris10 possibly with little bit of explanation. Thanks in advance, Chandra Sekhar.

3. Programming

Fork syscall and related issues

Hi all, i just started started learning system programming and want to pursue a career in the sys prog area. below is the program that use a fork() call. i read in one of the tutorials that parent process and child process uses different address spaces and runs concurrently. that meas each...

4. UNIX for Dummies Questions & Answers

Check for network issues

Hi all, How do i check for network issues on a server (solaris & linux) - interms of connectivity, collision, congestion, whatever that's impacting the connection to/from the server? Please advise. Thanks. :confused:

5. AIX

Network related errors

Hi How to check if my AIX server has any network related errors ?

6. Solaris

Swap space related issues, how to recognise the newly attached disk

hi!:) i got a problem....:wall::wall: i got several disks in my diskarray. I attached new disk to allocate it to the swap space. The problem is : how to recognise the newly attached disk? I've one more requirement -:wall:- i want to run dns service on another port number.how can i do...

7. HP-UX

Network Connectivity Issues

Newbie with UNIX here. Currently troubleshooting a UNIX terminal we have. I determined it to be bad and swapped it out with a known good terminal. I went in and changed the IP address and host name to reflect the old terminal. Although now there is no connectivity. I swapped out the NIC...

8. Shell Programming and Scripting

Network related script

First of all,I would like to introduce about me, This is my own try and this is not my homework,and I study myself reading shell script pdf guide from net and learn shell scripts bit by bit.I am self study learner.I try to work out shell scripts.please help to resolve this type of problem.when I...

LEARN ABOUT DEBIAN

mysql::diff::database

MySQL::Diff::Database(3pm)				User Contributed Perl Documentation				MySQL::Diff::Database(3pm)

NAME

       MySQL::Diff::Database - Database Definition Class

SYNOPSIS

	 use MySQL::Diff::Database;

	 my $db = MySQL::Diff::Database->new(%options);
	 my $source    = $db->source_type();
	 my $summary   = $db->summary();
	 my $name      = $db->name();
	 my @tables    = $db->tables();
	 my $table_def = $db->table_by_name($table);

	 my @dbs = MySQL::Diff::Database::available_dbs();

DESCRIPTION

       Parses a database definition into component parts.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       o   source_type()

	   Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.

       o   summary()

	   Provides a summary of the database.

       o   name()

	   Returns the name of the database.

       o   tables()

	   Returns a list of tables for the current database.

       o   table_by_name( $name )

	   Returns the table definition (see MySQL::Diff::Table) for the given table.

FUNCTIONS

   Public Functions
       o   available_dbs()

	   Returns a list of the available databases.

	   Note that is used as a function call, not a method call.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06						MySQL::Diff::Database(3pm)