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:\>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.
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
> > >
>
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
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
Hi,
Yes. There is the ISP's DNS. And of course it is unavailable
when the adsl connection is down.
I've deleted this DNS configuration but the problem persists.
And of course I have no explanation about why at the same time
others machines on the same local net, running Linux ( same version)
sound like windows is looking for something..
is there any kind of DNS lookup or a machine in the Network
Neighbourhood/Domain that might be unavailable when the adsl goes down?
Not a network expert, so just a guess 8-)
Peter
> -Original Message-
> From: Mauricio Pellegrini [mailto
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 = gateway
-
> From: Osus [mailto:[EMAIL 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 AN
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 buil
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
> t
l the records that have one "a".
Many 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,
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.
>
>
13 matches
Mail list logo
