Hi,
Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 .
I run under TCP Wrappers. Even if 1 foreign machine attempts
to contact us on the tcp port, the database becomes incredibly sluggish
or unresponsive at all.
Is there something I can do to prevent this from
:
Fax to:
07/13/2004 02:28 Subject: No Response from Server
AM
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
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
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,
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,
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+
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 advantage