Server overload problems

[Catalin Tenita]

Hi people,

Can you tell me how to monitor the server load and the mysql processes for a
a normal user on a shared Linux sistem.

We've launched a new version of our BestJobs.ro site (more complex in sql
queries than the last version) and it apperar that is crasching the machine,
by overloading it with mysql processes.
The machine is a dual 933's with 2 gig of ram and scsi drives, acting as
shared-hosting server.


Best Regards,
Catalin Tenita


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Server overload problems

[Ed Carp]

Catalin Tenita ([EMAIL PROTECTED]) writes:

 Hi people,
 
 Can you tell me how to monitor the server load and the mysql processes for a
 a normal user on a shared Linux sistem.

For monitoring the machine itself, I usually use top.  For monitoring the
database, I like mysqladmin processlist and mysqladmin status.  YMMV :)
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php