Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

filter show processlist

 
   Database Help (Home) -> mySQL RSS
Related Topics:
PLS HELP! - show databases and tables and columns - Hi, I just wonder if someone can help me with this: I need to create a sql script which will run when user my app. User may already have the database and tables tructure setup on the server, or may not. The script needs to..

Java mysql show table status - Hi, I am using java to retrieve a resultset with table mysql command. I am having problem reading the [name] and [engine] column. In the metadata object it is showing as VARCHAR but when I do it is returning me the object..

Best way to issue hundreds of inserts/updates??? - Using mysql 4.0.23- What is the best way to execute several (hundreds of) inserts and updates? Rather than issuing tons of inserts and updates, can I send the strings to a text file and then have mysql do them all?? IE : query.txt insert..

MySQL freezes, brings XP machine to a grinding halt - I've been using MySQL for a while for fairly light database on my XP machine. I am just starting a new project and have some big problems with MySQL today both on my office machine and at home where running a

login as user 'root' but do not have root privlages and my.. - Hi gang: I'm a problem with MySQL -- I updated MySQL from version 4.1.0 to 4.1.10 and now when I login as root it doesn't show all the databases I should have access to, nor it doesn't recognize me being logged in as root (via..
Next:  To_char problem  
Author Message
Sam

External


Since: Feb 10, 2005
Posts: 1



(Msg. 1) Posted: Thu Feb 10, 2005 12:40 pm
Post subject: filter show processlist
Archived from groups: mailing>database>mysql (more info?)

Is there a way to filter 'show processlist'?

like
show processlist where Host rlike "abc"

Thanks,
Sam

 >> Stay informed about: filter show processlist 
Back to top
Login to vote
bturczyn

External


Since: Jan 10, 2005
Posts: 7



(Msg. 2) Posted: Fri Feb 11, 2005 1:47 pm
Post subject: Re: filter show processlist [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In looking at the mysql doc it loooks like this isn't possible:
13.5.4.15. SHOW PROCESSLIST Syntax

SHOW [FULL] PROCESSLIST
http://dev.mysql.com/doc/mysql/en/show-processlist.html

But, a couple of ways that I achieve this is by using the command below
if you have grep and cut availble:

mysqladmin processlist | grep <host> | cut -d '|' -f1-8

Or by installing mytop which allows you to filter on host using regexp


http://jeremy.zawodny.com/mysql/mytop/

 >> Stay informed about: filter show processlist 
Back to top
Login to vote
bturczyn

External


Since: Jan 10, 2005
Posts: 7



(Msg. 3) Posted: Fri Feb 11, 2005 1:55 pm
Post subject: Re: filter show processlist [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In looking at the mysql doc it loooks like this isn't possible:
13.5.4.15. SHOW PROCESSLIST Syntax

SHOW [FULL] PROCESSLIST
http://dev.mysql.com/doc/mysql/en/show-processlist.html

But, a couple of ways that I achieve this is by using the command below
if you have grep and cut availble:

mysqladmin processlist | grep <host> | cut -d '|' -f1-8

Or by installing mytop which allows you to filter on host using regexp


http://jeremy.zawodny.com/mysql/mytop/
 >> Stay informed about: filter show processlist 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]