Have you checked your slow query log and your error logs? Depending on
your usage patterns, you may need to optimize some of your queries. Is
your MySQL server sharing CPU time with any other applications? How many?
Could they be the cause of your CPU usage spike?
To the list: (This may or
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
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