On Fri, 5 Oct 2001, Dan Nelson wrote:
> This rules out mysql as the cause for the delay.
I agree.
> > > I'd say start dumping packets on the network.
> >
> > I'd agree, but I'm confused as to why a different query (that
> > requests more data; 33 rows vs 1) can reliably execute and fetch in
> >
In the last episode (Oct 05), Philip Brown said:
> > What are your timings if you run your client on the SCO box? mysql
> simply reports a query time of 10ms or less (0.01s). Of course, this
> doesn't have any network overhead.
This rules out mysql as the cause for the delay.
> > I'd say star
On Fri, 5 Oct 2001, Philip Brown wrote:
> > How is your DNS, WINS,... setup? SCO/Caldera UNIX can use DNS when you do
> > not think it will. Most SCO/Caldera tcp what ever will do a forward and
> > reverse DNS look-up. I can add entries in the MS machines in the hosts
> > file location MS OS/in
> I suppose your test program connects, and loops the same query multiple
> times in the same session? (Just to rule out connect/disconnect
> overhead)
Of course. I also run the same query multiple times, to eliminate caching
issues. Performance on successive iterations is the same as on the fir
>
> - Original Message -
> From: "Philip Brown" <[EMAIL PROTECTED]>
> To: "Russell Miller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, October 05, 2001 1:34 PM
> Subject: RE: Bizarre query performance
>
>
> >
> How is your DNS, WINS,... setup? SCO/Caldera UNIX can use DNS when you do
> not think it will. Most SCO/Caldera tcp what ever will do a forward and
> reverse DNS look-up. I can add entries in the MS machines in the hosts
> file location MS OS/install dependent and very times.
All machines ha
In the last episode (Oct 05), Philip Brown said:
> Server: SCO OpenServer V3.2 R5.0.5, AMD K6-2 350Mhz CPU, 128Mb RAM
> mySQL: 3.23.39, compiled by me to avoid use of libraries, using latest
> available pthreads
>
> Clients: Win32 machines (more detail later).
>
> There are 2 times I am interest
OTECTED]>
Sent: Friday, October 05, 2001 1:34 PM
Subject: RE: Bizarre query performance
> > Have you tried "explain"ing the two select to see where all the time is
> > being spent and how the queries a
On Fri, 5 Oct 2001, Philip Brown wrote:
> Environment:
>
> Server: SCO OpenServer V3.2 R5.0.5, AMD K6-2 350Mhz CPU, 128Mb RAM
> mySQL: 3.23.39, compiled by me to avoid use of libraries, using latest
> available pthreads
... much deleted...
> Can anyone give me some assistance with this bizarre b
> Have you tried "explain"ing the two select to see where all the time is
> being spent and how the queries are optimized?
Sorry, I should have included that in my detail.
+---+---+---+-+-+---+--+---+
| table | type | possible_keys | key | key
Have you tried "explain"ing the two select to see where all the time is
being spent and how the queries are optimized?
--Russell
- Original Message -
From: "Philip Brown" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 05, 200
I have been testing an application that uses mysql on SCO OpenServer and I
have discovered some strange query performance. To investigate the matter
further, I have written a client program that uses the mysql C API directly
so that I can time things exactly.
Environment:
Server: SCO OpenServer
12 matches
Mail list logo
