t is:
> >mysqladmin: connect to server at 'localhost' failed
> >error: 'Access denied for user: 'webmail@localhost' (Using password:
> >NO)'
(* OK so mySQL is opensource, so the answer to my question is obviously
"because no-one has though
it was One Of Those Days (TM) :-( )
What would I have looked for in the show processlist output?
On Tue, 16 Jan 2001, Dan Nelson wrote:
> In the last episode (Jan 17), John Stumbles said:
> > SELECT * from MAC_connections
> > or even
> > SELECT count(*) from MAC_connections
> &
On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote:
> On Tue, Jan 16, 2001 at 08:21:19PM +0000, John Stumbles wrote:
>
> > I can't readily reproduce the first-time big difference
> > scenario.
OK, I can now: I have a table -
MAC_connections:
aching when doing sort of variations on a basic
query (e.g. joining in on another table). I just wondered if mySQL was
doing some cunning optimisation after the first big hit.
regards,
--
John Stumbles
value}
My MAC_Connections table is indexed on MAC, and IP_MAC is indexed on MAC.
mySQL Version is 3.22.32
regards,
--
John Stumbles [EMAIL PROTECTED]
I.T. Services Centre, University of Read
