Re: Viewing the server commands

On 23/12/14 02:50, Stefan Ram wrote:
> "Peter H. Coffin" <hellsop_at_ninehells.com> writes:
>> won't bypass anything. Or the OP is trying the right thing but doesn't
>> have the charset environment set right for some of the names. Etc. The
>
> One source said SHOW was executed in the monitor,
> while another source said, it was executed in the server,
> so I wanted to observe myself where it was interpreted.
>
> Later I became aware that SHOW is being described under
>
> HELP CONTENTS
>
> not under
>
> HELP
>
> , so it should be interpreted by the server. Otherwise,
> I would have used the server command log (in the meantime,
> I got this running, thank you, Luuk!) to see what the
> monitor actually sends to the server. »USE« is an example of
> a command that is not directly sent to the server.
>
> FWIW, in the meantime, I also discovered a piece of software
> by Oracle that is called »MySQL Proxy« that might help to
> view the commands send to the server. But I still need to
> learn how to properly install and set-up this piece of software.
>
I think you should understand and study the relationship between the server, the client API libraries and the applications that use them, and how communication takes place between them.

And then decide whether the client libraries that access the server are 'part of the server' or 'part of the application'..and whether examining the traffic in that chain at any point is in any way useful or not.

-- 
Everything you read in newspapers is absolutely true, except for the 
rare story of which you happen to have first-hand knowledge. – Erwin Knoll