About mysql show processlist

byran cheung · 03-25-2015, 09:25 PM

I have connected to mysql console by "mysql -uroot -p" , then use the command "show processlist ;" to list the processes , but I can't see the result , may be the command is too long , the column only allow around 85 characters , the command should over the limit , how can I see the full command ?

thanks

Habitual · 03-26-2015, 10:10 AM

I'd try to use it like so:

Code:

mysql -uroot -p -e "show processlist;"

If you don't need the table layout use,

Code:

mysql -uroot -p -e "show processlist;" -Ns

byran cheung · 03-26-2015, 09:14 PM

thanks reply ,

but it seems still can not show all command ,

I tried find from mysql man page , but could not find what is the parameter -Ns but could not find it . would advise more information about the table layout display ? thanks

http://linux.die.net/man/1/mysql

Habitual · 03-27-2015, 09:23 AM

Code:

man mysql

for
DESCRIPTION and
--skip-column-names, -N

Go fish!