What is the amout of volume? Are you reaching max connections? What does the
I/0 look like?
-Original Message-
From: [EMAIL PROTECTED]
To: s.ahmad
Cc: [EMAIL PROTECTED]
Sent: 7/14/04 7:51 AM
Subject: Re: No Response from Server
Have you checked your slow query log and your error
om> cc:
Fax to:
07/13/2004 02:28 Subject: No Response from Server
On Tue, 13 Jul 2004, s.ahmad wrote:
> 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 adva
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
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
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,
>
>
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
