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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
