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 > > <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- > s.ahmad <[EMAIL PROTECTED]> > 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/[EMAIL PROTECTED]