Hi


I have a linux box Red hat 8.0 installed
The Hardware configuratuion is fine with Pentum111 and 256 MB RAM

Now I am using my machine and the same time i give access to others user to access my machine through VNCserver
They access it by VNCveiwer and also through telnet

They specially use it for Database accessing(Postgresql)

So when others user uses my machine and he tries to insert bulk data into the database
automatically I cannot use my session it is get slow and not able to even move my mouse

So can anyone tell me how to fine tune the performance of my machine

i.e. I should to restrict the other user sharing the system resourses.It should be evenly distributed that is the other user should be restricted from using more resourses
so i should also be able to work in my machine smoothly while other user using my machines

My point is the other user should using the system resourses evenly I do not bother about the time ,Let it take more time
but I should also be able to access my machine smoothly when other user inserts data and others from remotely

So how to share the resoures and allocate quota
Guide me

regards
Sabeer

Firstly you'll have to check using top
which process(es) actually grab(s) the CPU
and look at the memory footprints and
swap activity ...

I don't think that you should be using
VNC to toy with the database, I'd recommend
to either create a little frontend for the client-side
or build a web-page that allows data manipulation.

Cheers,
Tink

Performance tuning - especially with databases - can be an artform. In most cases that I've ever dealt with (this includes multiple Sybase and Oracle deployments on HPUX and Solaris), I/O is the limiting factor. Most performance improvements were achieved on the database or application side. This may or may not be true for your system. Definitely check top and memory. But, let's assume that its I/O.

With Linux, the version of the kernel cannot be discounted. For example, on my RH 7.0 partition I get a throughput of about 2.5 MB/s to the IDE disks, where as on my LFS 4.1 partition I get about 32 MB/s - same CPU/RAM/hard drive. The kernel is the difference. In the 2.2.16 kernel on RH 7.0, DMA is not detected properly, whereas the 2.4.20 kernel on my LFS 4.1 detects DMA automatically. Also, I'm sure that there are various memory handling improvements between 2.2.14 and 2.4.20.

There is a nice little application for changing I/O parameters for the hard drive, called hdparm:

http://freshmeat.net/projects/hdparm/

But BE CAREFUL!!! Evidently, there is some evidence (albeit anecdotal) that this program can corrupt hard drives.

Hope this helps...

man hdparm

hi Sabeer,

first thing for fine tuning the machine should be compiling an appropriate kernel for your machine...