LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-25-2015, 09:25 PM   #1
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Rep: Reputation: Disabled
About mysql show processlist


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
 
Old 03-26-2015, 10:10 AM   #2
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,555
Blog Entries: 13

Rep: Reputation: Disabled
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
 
Old 03-26-2015, 09:14 PM   #3
byran cheung
Member
 
Registered: Sep 2013
Posts: 321

Original Poster
Rep: Reputation: Disabled
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
 
Old 03-27-2015, 09:23 AM   #4
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 8,555
Blog Entries: 13

Rep: Reputation: Disabled
Code:
man mysql
for
DESCRIPTION and
--skip-column-names, -N

Go fish!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
count mysql processlist and return value sir-lancealot Linux - Server 2 03-01-2012 09:09 AM
Apache hanged with lots of process in processlist tanveer Linux - Server 2 02-19-2009 07:53 PM
show date in mysql bentman78 Linux - Software 0 05-17-2004 11:44 AM
MySQL: Show Table figadiablo Programming 3 03-04-2004 09:30 AM
PHP does not show mysql as an extension Linix Linux - Newbie 7 01-31-2004 09:13 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:08 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration