On Wed, 23 Jan 2002 16:53:47 -0800
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> In sql/sql_parse.cc:72 (roughly), a list of command names is defined:
>
> const char *command_name[]={
> "Sleep", "Quit", "Init DB", "Query", "Field List", "Create DB",
> "Drop DB", "Refresh", "Shutdown", "Statistics", "Processlist",
> "Connect","Kill","Debug","Ping","Time","Delayed_insert","Change
> user","Binlog Dump","Table Dump", "Connect Out", "Register Slave"
> };
>
> This appears to correspond to what normally shows up in the "Command"
> field of SHOW PROCESSLIST.
>
> I can see that many of those "commands" follow directly from the C
> API. However, there are a few questions I have:
>
> (1) Can all of those show up in the SHOW PROCESSLIST output at some
> time or another?
>
Yes.
> (2) Can someone give me an idea what these correspond to:
>
> Connect Out
> Init DB
Change database
> Refresh
FLUSH PRIVILEGES
> Quit (is this when a client closes the connection?)
termination of the thread
> Shutdown
Shutdown of MySQL server.
> Register Slave (when a slave first connects, before Binlog Dump?)
>
Yes.
> I'd be happy to patch the manual with this documentation once it is
> done. So far, most of it appears not to be there.
>
> Thanks,
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 21 days, processed 483,850,069 queries (265/sec.
> avg)
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail [EMAIL PROTECTED]
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
>
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
