Hello,
we encounter a strange behaviour in one of our Database Server.
Our setup consists of a SUN V440 which has mounted a NFS Share from a Network
Appliance File Server.
This setup have been running a long term without complications although we knew
that there are many statements concerning
?
Not a network expert, so just a guess 8-)
Peter
-Original Message-
From: Mauricio Pellegrini [mailto:[EMAIL PROTECTED]
Sent: 04 June 2004 00:44
To: MySql List
Subject: Slow querys When ADSL is down on W2K
Hi,
This seems to be a strange situation.
I have a server
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k IP 192.168.10. 5 Gets slow when adsl is down
Lin_box1 (SuSE 8.2) IP 192.168.10. 3
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k IP 192.168.10. 5 Gets slow when adsl is down
On Tue, 2004-06-08 at 12:57, John Fawcett wrote:
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k
From: Mauricio Pellegrini On Tue, 2004-06-08 at 12:57, John Fawcett
wrote:
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP
The only thing strange about this is that in your previous
post you mentioned that the wk2 machine had an ip of
192.168.10.5.
Yes, that example was from another machine on the same net
The above route print output seems to be for a machine
with an ip of 192.168.10.2.
Yes. In this
From: Mauricio Pellegrini
Oh no.. The reason is I've changed my seat. All IP's are static.
Sorry :)
It generally helps to keep the problem conditions the same while
investigating. :)
I forgot that Here is the result of Ipconfig /all on the same machine
(192.168.10.2)
C:\ipconfig /all
Hi,
This seems to be a strange situation.
I have a server ( Sun fire v65x ) running
SuSE 8.2 and My-Sql 4.1.1alpha-max.
I've detected that when our adsl internet connection is down
the querys on our local network turns to be unusually slow.
But this situation occurs only when querys are
I'd suggest you add a static route to the W2k clients just to see if
that corrects the problem... try this command:
route ADD ddd.ddd.ddd.ddd MASK mmm.mmm.mmm.mmm ggg.ggg.ggg.ggg
d = destination (the mysql DB server)
m = subnet mask (255.255.255.0 or whatever your route happens to be)
g =
:[EMAIL PROTECTED]
Sent: 04 June 2004 00:44
To: MySql List
Subject: Slow querys When ADSL is down on W2K
Hi,
This seems to be a strange situation.
I have a server ( Sun fire v65x ) running
SuSE 8.2 and My-Sql 4.1.1alpha-max.
I've detected that when our adsl internet connection is down
of that querys take 16 or 20 seconds.
what do you think?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jesus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 12:08 AM
Subject: Re: slow querys
On Tue, Aug 21, 2001 at 10:04:58PM +0200, Jesus wrote
On 22-Aug-2001 Osus wrote:
Hi,
The slow queries are those like...
SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
where table have about 20.000 records and field is a text field.
I need to find ALL the records that have text, even if text is a i have
to find all
The slow queries are those like...
SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
WHERE field like '%text%' -- this will not use an index. Read the manual
about fulltext. It may or may meet your needs. It works pretty good. If the
text is a word you could also build a word
PROTECTED]]
Sent: Wednesday, August 22, 2001 4:17 PM
To: [EMAIL PROTECTED]
Subject: Re: slow querys
Hi,
The slow queries are those like...
SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
where table have about 20.000 records and field is a text field
Threads: 12 Questions: 107446 Slow queries: 485 Opens: 88 Flush tables: 1
Open tables: 82 Queries per second avg: 42.722
--
Why have I so many slow querys???
I can't understand, but the performance get down.
I have Mysql/apache/php
it's a web aplication
what can i do?
thanks
On Tue, Aug 21, 2001 at 10:04:58PM +0200, Jesus wrote:
Threads: 12 Questions: 107446 Slow queries: 485 Opens: 88 Flush tables: 1
Open tables: 82 Queries per second avg: 42.722
--
Why have I so many slow querys???
I can't understand, but the performance get down.
I have
17 matches
Mail list logo