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]
