Server not responding

------=_NextPart_000_0024_01C5400F.96F2D170
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,
I'm having some odd problems with my server. About once a week, it =
seems to stop responding to all queries, or taking a very long time to =
respond. (an hour or more.)
Under normal circumstances, it is processing about 85-100 queries per =
second, without any real problems.
When it plays up, it accepts connections OK, but all queries seem to =
hang.
Attempting to restart the service results in CPU utlisation going to =
100% and staying there. The process dies and nobody can connect any =
more, but Wndows doesn't accept that the service has stopped. The only =
solution is to reboot the machine.
Using version 4.0.15 on a P4 with 1GB of RAM.
Anybody seen this kind of behaviour before?

Regards,
Leigh
=20
Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

------=_NextPart_000_0024_01C5400F.96F2D170--

Re: Server not responding

------=_NextPart_000_0034_01C54011.8A14FC60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

>On the version - you mean NT right?

Yes.

>What hardware are you running?=20

2.8Ghz P4. 1Gb RAM, 2 x 120GB HDD, RAIDed

>Do you have any other services that start at or about the same time =
that this happens?=20

No. Timing appears to be completely random. At first it happened about =
once a week, but this week I've had three occurences.

=20

----- Original Message -----=20
From: Wade=20
To: Leigh Sharpe=20
Sent: Wednesday, April 13, 2005 10:07 AM
Subject: Re: Server not responding


04122005 1904 GMT-6

What hardware are you running?=20
On the version - you mean NT right?
Do you have any other services that start at or about the same time =
that this happens?=20

Wade


Leigh Sharpe wrote:

Hi All,
I'm having some odd problems with my server. About once a week, it =
seems to stop responding to all queries, or taking a very long time to =
respond. (an hour or more.)
Under normal circumstances, it is processing about 85-100 queries per =
second, without any real problems.
When it plays up, it accepts connections OK, but all queries seem to =
hang.
Attempting to restart the service results in CPU utlisation going to =
100% and staying there. The process dies and nobody can connect any =
more, but Wndows doesn't accept that the service has stopped. The only =
solution is to reboot the machine.
Using version 4.0.15 on a P4 with 1GB of RAM.
Anybody seen this kind of behaviour before?

Regards,
Leigh
=20
Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

=
------------------------------------------------------------ -------------=
---
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005

------=_NextPart_000_0034_01C54011.8A14FC60--

Re: Server not responding

------=_NextPart_000_003D_01C54017.86777B90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

>What do you server logs say (apache?);

Logs all look normal. Nothing outstanding.

The server issues don't look like they are related to apache.
We have several processes which are constantly updating the database, =
about every 30 seconds or so. These have been running for over 12 months =
without hiccups, though, but the server has just recently started =
playing up.


----- Original Message -----=20
From: Wade=20
To: Leigh Sharpe=20
Sent: Wednesday, April 13, 2005 10:27 AM
Subject: Re: Server not responding


04122005 1923 GMT-6

What do you server logs say (apache?);
Im assuming that this is connected to the net.=20

Im going to assume a lot more here.=20

You might look to see if the server is going down when a certain page =
is accessed, or you might even look at your logs for a certain ip =
address.=20

Wade



Leigh Sharpe wrote:

On the version - you mean NT right?
=20
Yes.

What hardware are you running?=20
=20
2.8Ghz P4. 1Gb RAM, 2 x 120GB HDD, RAIDed

Do you have any other services that start at or about the same time =
that this happens?=20
=20
No. Timing appears to be completely random. At first it happened about =
once a week, but this week I've had three occurences.

=20

----- Original Message -----=20
From: Wade=20
To: Leigh Sharpe=20
Sent: Wednesday, April 13, 2005 10:07 AM
Subject: Re: Server not responding


04122005 1904 GMT-6

What hardware are you running?=20
On the version - you mean NT right?
Do you have any other services that start at or about the same time =
that this happens?=20

Wade


Leigh Sharpe wrote:

Hi All,
I'm having some odd problems with my server. About once a week, it =
seems to stop responding to all queries, or taking a very long time to =
respond. (an hour or more.)
Under normal circumstances, it is processing about 85-100 queries per =
second, without any real problems.
When it plays up, it accepts connections OK, but all queries seem to =
hang.
Attempting to restart the service results in CPU utlisation going to =
100% and staying there. The process dies and nobody can connect any =
more, but Wndows doesn't accept that the service has stopped. The only =
solution is to reboot the machine.
Using version 4.0.15 on a P4 with 1GB of RAM.
Anybody seen this kind of behaviour before?

Regards,
Leigh
=20
Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

=
------------------------------------------------------------ -------------=
---
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005
=20
=
------------------------------------------------------------ -------------=
---
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005

------=_NextPart_000_003D_01C54017.86777B90--

Re: Server not responding

> Any chance you have an error is the indices or some such craziness? THere
> might be some process inserting something that is allowed on 1 index but
> violates another.

Unlikely. As far as I'm aware, there is only one index on any given table.


----- Original Message -----
From: "Leif Johnston"
To: "Leigh Sharpe"
Sent: Wednesday, April 13, 2005 11:01 AM
Subject: Re: Server not responding


> Any chance you have an error is the indices or some such craziness? THere
> might be some process inserting something that is allowed on 1 index but
> violates another.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Server not responding

You can try to stop all processes which update your databases and connecto
to mysql server manualy and run some "OPTIMIZE TABLE ..."
Are you using MyISAM or InnoDB?


Petr Vileta, Czech republic
(My server reject all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)


----- Original Message -----
From: "Leigh Sharpe"
To: ; "Wade"
Sent: Wednesday, April 13, 2005 2:57 AM
Subject: Re: Server not responding


>What do you server logs say (apache?);

Logs all look normal. Nothing outstanding.

The server issues don't look like they are related to apache.
We have several processes which are constantly updating the database, about
every 30 seconds or so. These have been running for over 12 months without
hiccups, though, but the server has just recently started playing up.


----- Original Message -----
From: Wade
To: Leigh Sharpe
Sent: Wednesday, April 13, 2005 10:27 AM
Subject: Re: Server not responding


04122005 1923 GMT-6

What do you server logs say (apache?);
Im assuming that this is connected to the net.

Im going to assume a lot more here.

You might look to see if the server is going down when a certain page is
accessed, or you might even look at your logs for a certain ip address.

Wade



Leigh Sharpe wrote:

On the version - you mean NT right?

Yes.

What hardware are you running?

2.8Ghz P4. 1Gb RAM, 2 x 120GB HDD, RAIDed

Do you have any other services that start at or about the same time that
this happens?

No. Timing appears to be completely random. At first it happened about once
a week, but this week I've had three occurences.



----- Original Message -----
From: Wade
To: Leigh Sharpe
Sent: Wednesday, April 13, 2005 10:07 AM
Subject: Re: Server not responding


04122005 1904 GMT-6

What hardware are you running?
On the version - you mean NT right?
Do you have any other services that start at or about the same time that
this happens?

Wade


Leigh Sharpe wrote:

Hi All,
I'm having some odd problems with my server. About once a week, it seems to
stop responding to all queries, or taking a very long time to respond. (an
hour or more.)
Under normal circumstances, it is processing about 85-100 queries per
second, without any real problems.
When it plays up, it accepts connections OK, but all queries seem to hang.
Attempting to restart the service results in CPU utlisation going to 100%
and staying there. The process dies and nobody can connect any more, but
Wndows doesn't accept that the service has stopped. The only solution is to
reboot the machine.
Using version 4.0.15 on a P4 with 1GB of RAM.
Anybody seen this kind of behaviour before?

Regards,
Leigh

Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

------------------------------------------------------------ --------------
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005

------------------------------------------------------------ --------------
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Server not responding

----- Original Message -----
From: "Petr Vileta"
To:
Sent: Wednesday, April 13, 2005 11:26 AM
Subject: Re: Server not responding


> You can try to stop all processes which update your databases and connecto
> to mysql server manualy and run some "OPTIMIZE TABLE ..."

I optimize all tables weekly.
I also did a myisamchk -r -n on all tables recently. Made no difference.

> Are you using MyISAM or InnoDB?
>

I'm using myISAM.



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Server not responding

The log does have some entries indicating bad blocks on the disk.
It doesn't coincide with the server problems, but looks like it's worth
investigating.

----- Original Message -----
From: "Raúl D. Pittí Palma"
To: "Leigh Sharpe"
Sent: Wednesday, April 13, 2005 3:58 PM
Subject: Re: Server not responding


> have you look at the system log ?.. errr .. event viewer in windows...
> search for hard disk failures....
>
>
> do you have any antivirus running concurrently on the server?
>
> I really recommend you to discard any hardware problem first.. i.e.
> broken cpu fan or chassis fan are usually the responsibles for weird
> behavior..
> regards!!
> RP
>
>
>
> Leigh Sharpe wrote:
> > ----- Original Message -----
> > From: "Petr Vileta"
> > To:
> > Sent: Wednesday, April 13, 2005 11:26 AM
> > Subject: Re: Server not responding
> >
> >
> >
> >>You can try to stop all processes which update your databases and
connecto
> >>to mysql server manualy and run some "OPTIMIZE TABLE ..."
> >
> >
> > I optimize all tables weekly.
> > I also did a myisamchk -r -n on all tables recently. Made no difference.
> >
> >
> >>Are you using MyISAM or InnoDB?
> >>
> >
> >
> > I'm using myISAM.
> >
> >
> >
>
> --
> --------------------
> Raúl D. Pittí Palma
> Associate
> Global Engineering and Technologies
> mobile (507)-616-0194
> office (507)-264-2362
> Republic of Panama
> www.globaltecsa.com
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Server not responding

Sounds like a memory leak problem which always requires a reboot - look =
for a process that whose usage you have increased.=20

Look to processes on home brewed software * yours or something you out =
sourced

May not be MySql but your server side scripting or even your antivirus or =
backup software (we were just down that road).

>>> "Leigh Sharpe" 04/13/05 1:31 AM >>>
The log does have some entries indicating bad blocks on the disk.
It doesn't coincide with the server problems, but looks like it's worth
investigating.

----- Original Message -----=20
From: "Ra=FAl D. Pitt=ED Palma"
To: "Leigh Sharpe"
Sent: Wednesday, April 13, 2005 3:58 PM
Subject: Re: Server not responding


> have you look at the system log ?.. errr .. event viewer in windows...
> search for hard disk failures....
>
>
> do you have any antivirus running concurrently on the server?
>
> I really recommend you to discard any hardware problem first.. i.e.
> broken cpu fan or chassis fan are usually the responsibles for weird
> behavior..
> regards!!
> RP
>
>
>
> Leigh Sharpe wrote:
> > ----- Original Message -----=20
> > From: "Petr Vileta"
> > To:
> > Sent: Wednesday, April 13, 2005 11:26 AM
> > Subject: Re: Server not responding
> >
> >
> >
> >>You can try to stop all processes which update your databases and
connecto
> >>to mysql server manualy and run some "OPTIMIZE TABLE ..."
> >
> >
> > I optimize all tables weekly.
> > I also did a myisamchk -r -n on all tables recently. Made no difference=
..
> >
> >
> >>Are you using MyISAM or InnoDB?
> >>
> >
> >
> > I'm using myISAM.
> >
> >
> >
>
> --=20
> --------------------
> Ra=FAl D. Pitt=ED Palma
> Associate
> Global Engineering and Technologies
> mobile (507)-616-0194
> office (507)-264-2362
> Republic of Panama
> www.globaltecsa.com=20
>


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32=20
To unsubscribe: http://lists.mysql.com/win32?unsub=3Djbogren@river.cc.mn=
..us=20



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Server not responding

You should start your server with --log-warnings and take a look at
the warnings page, maybe you're gettings lots of hanged connections
(it happened to me once), take a look at your thread config, maybe
you're running too much threads at once without disconnecting (this
would be related to warnings comming from the options I mentioned
before). Are you using NTFS? I noticed some problems related to
indexes and queries with LIMIT on systems using the
lower_case_table_names option and NTFS (winxp), I eliminated each one
(LIMIT, lower case, of course could not remove the NTFS) and it worked
much better. Take a look at the memory usage for the server.

As Jerry stated, lots of connections means lots of threads, that use
lots of space and eventually disk, Apache even creates a single file
for each session started, so, there are lots of disk access, and a
antivirus would block, check and then resume each one.

This looks more like an OS config than a MySQL one, because you stated
you had it running for some time, any system changes (hardware,
software)?

On 4/13/05, Jerry Bogren wrote:
> Sounds like a memory leak problem which always requires a reboot - look f=
or a process that whose usage you have increased.
>=20
> Look to processes on home brewed software * yours or something you out s=
ourced
>=20
> May not be MySql but your server side scripting or even your antivirus or=
backup software (we were just down that road).
>=20
> >>> "Leigh Sharpe" 04/13/05 1:31 AM >>>
> The log does have some entries indicating bad blocks on the disk.
> It doesn't coincide with the server problems, but looks like it's worth
> investigating.
>=20
> ----- Original Message -----
> From: "Ra=FAl D. Pitt=ED Palma"
> To: "Leigh Sharpe"
> Sent: Wednesday, April 13, 2005 3:58 PM
> Subject: Re: Server not responding
>=20
> > have you look at the system log ?.. errr .. event viewer in windows..=
..
> > search for hard disk failures....
> >
> >
> > do you have any antivirus running concurrently on the server?
> >
> > I really recommend you to discard any hardware problem first.. i.e.
> > broken cpu fan or chassis fan are usually the responsibles for weird
> > behavior..
> > regards!!
> > RP
> >
> >
> >
> > Leigh Sharpe wrote:
> > > ----- Original Message -----
> > > From: "Petr Vileta"
> > > To:
> > > Sent: Wednesday, April 13, 2005 11:26 AM
> > > Subject: Re: Server not responding
> > >
> > >
> > >
> > >>You can try to stop all processes which update your databases and
> connecto
> > >>to mysql server manualy and run some "OPTIMIZE TABLE ..."
> > >
> > >
> > > I optimize all tables weekly.
> > > I also did a myisamchk -r -n on all tables recently. Made no differen=
ce.
> > >
> > >
> > >>Are you using MyISAM or InnoDB?
> > >>
> > >
> > >
> > > I'm using myISAM.
> > >
> > >
> > >
> >
> > --
> > --------------------
> > Ra=FAl D. Pitt=ED Palma
> > Associate
> > Global Engineering and Technologies
> > mobile (507)-616-0194
> > office (507)-264-2362
> > Republic of Panama
> > www.globaltecsa.com
> >
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Djbogren@river.cc.=
mn.us
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Server not responding

saludos desde panama!!!
well.. you should backup all the mysql databases, and change that hard
disk immediately..
this is pretty much the cause of the failure..
good luck!!
RP

Leigh Sharpe wrote:
> The log does have some entries indicating bad blocks on the disk.
> It doesn't coincide with the server problems, but looks like it's worth
> investigating.
>
> ----- Original Message -----
> From: "Raúl D. Pittí Palma"
> To: "Leigh Sharpe"
> Sent: Wednesday, April 13, 2005 3:58 PM
> Subject: Re: Server not responding
>
>
>
>>have you look at the system log ?.. errr .. event viewer in windows...
>> search for hard disk failures....
>>
>>
>>do you have any antivirus running concurrently on the server?
>>
>>I really recommend you to discard any hardware problem first.. i.e.
>>broken cpu fan or chassis fan are usually the responsibles for weird
>>behavior..
>>regards!!
>>RP
>>
>>
>>
>>Leigh Sharpe wrote:
>>
>>>----- Original Message -----
>>>From: "Petr Vileta"
>>>To:
>>>Sent: Wednesday, April 13, 2005 11:26 AM
>>>Subject: Re: Server not responding
>>>
>>>
>>>
>>>
>>>>You can try to stop all processes which update your databases and
>
> connecto
>
>>>>to mysql server manualy and run some "OPTIMIZE TABLE ..."
>>>
>>>
>>>I optimize all tables weekly.
>>>I also did a myisamchk -r -n on all tables recently. Made no difference.
>>>
>>>
>>>
>>>>Are you using MyISAM or InnoDB?
>>>>
>>>
>>>
>>>I'm using myISAM.
>>>
>>>
>>>
>>
>>--
>>--------------------
>>Raúl D. Pittí Palma
>>Associate
>>Global Engineering and Technologies
>>mobile (507)-616-0194
>>office (507)-264-2362
>>Republic of Panama
>>www.globaltecsa.com
>>
>
>
>
>

--
--------------------
Raúl D. Pittí Palma
Associate
Global Engineering and Technologies
mobile (507)-616-0194
office (507)-264-2362
Republic of Panama
www.globaltecsa.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Server not responding

Hi All,
Thanks for you responses. At this stage it looks like it's actually a
hardware issue. Windows is telling me I've got errors on one of my disks.
This is the most likely cause of the problem, it seems.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org