[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: No Response from Server
From:       "Joshua J. Kugler" <jkugler () bigfoot ! com>
Date:       2004-07-13 7:12:16
Message-ID: 200407122312.16498.jkugler () bigfoot ! com
[Download RAW message or body]

50 clients accessing the database should not overload a system like that.  I 
would recommend posting your database layout.  That might help in diagnosing 
the problem.

j----- k-----

On Monday 12 July 2004 11:08 pm, s.ahmad said something like:
> thankyou for your kind attention.
>
> there are 50+ Reservation stations in the country. Where multiple
> operators are sitting and reserving seats. Indexes are being used in
> the DB. as i am related to hosting company, i havent seen if they are
> taking advantage of indexes.
>
>
> regards,
> s.ahmad
>
> On Mon, 12 Jul 2004 22:36:10 -0800, Joshua J. Kugler
>
> <jkugler@bigfoot.com> wrote:
> > Can you give us more insight into your database layout?
> > Are you using indexes?
> > How many clients are accessing it?
> > What kind of queries?
> > Are those queries written to take advantage of the indexes?
> >
> > j----- k-----
> >
> > On Monday 12 July 2004 10:28 pm, s.ahmad said something like:
> > > Hello,
> > >  Dear All,
> > >
> > >
> > > i'm now a days having quite big problem, i would like to get help from
> > > you guyz, ...  we have Railways Reservation System of whole country
> > > hosted on our servers which is purely in php MYSQL.
> > >
> > > problem is that when the country wide offices start working, our
> > > server CPU uUsage goes upto 99% and oftenly it chokes the server. We
> > > tried it on blank server with only 1 site hosted. the server specs
> > > were
> > >
> > > 1 GB RAM
> > > Xeon Dual Processor
> > > 100 GB HDD
> > >
> > > but same, a blank serevr was also choked by the usage. This started
> > > happening bcz. DB is growing day by day and is quite big in size. Can
> > > any body tell me what can i do. Should i use MYSQL Clusters or any
> > > other thing ... i'll be so gratefull
> > >
> > > regards,
> > > s.ahmad
> > > Lahore, Pakistan
> >
> > --
> > Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
> > Every knee shall bow, and every tongue confess, in heaven, on earth, and
> > under the earth, that Jesus Christ is LORD -- Count on it!
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:   
> > http://lists.mysql.com/mysql?unsub=shakeelahmad@gmail.com
>
> --
> s.ahmad <shakeelahmad@gmail.com>
> www.shakeelahmad.net

-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]