SEO

#1 (**permalink**) 02-28-2008, 07:02 AM

hi..

simple question!!

mysql> show slave status

returns a number of fields, with information on the status of the slave. is
there a way to only return the field(s) i'm interested in...

i thought that i had figured this out, but i can't recall, and it's been
awhile since i've played with this!

thanks

#2 (**permalink**) 02-28-2008, 07:02 AM

You can set pager command to grep out unwanted fields.

On 11/28/07, bruce <bedouglas@earthlink.net> wrote:
> hi..
>
> simple question!!
>
> mysql> show slave status
>
> returns a number of fields, with information on the status of the slave. is
> there a way to only return the field(s) i'm interested in...
>
> i thought that i had figured this out, but i can't recall, and it's been
> awhile since i've played with this!
>
> thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=a...rthu@gmail.com
>
>

--
Sent from Gmail for mobile | mobile.google.com

Thanks
Alex
http://alexlurthu.wordpress.com

#3 (**permalink**) 02-28-2008, 07:02 AM

hi alex..

thanks for the reply. but i thought i had seen a way in mysql, to specify
the given field that i want. the "show slave status" cmd obviously displays
a list of fields, so i'm pretty sure that there should be a way of just
displaying the targeted field, without having to parse using grep...

thanks

-----Original Message-----
From: Alex Arul Lurthu [mailto:alex.lurthu@gmail.com]
Sent: Tuesday, November 27, 2007 7:19 PM
To: bruce; mysql list
Subject: Re: "show slave staus"

You can set pager command to grep out unwanted fields.

On 11/28/07, bruce <bedouglas@earthlink.net> wrote:
> hi..
>
> simple question!!
>
> mysql> show slave status
>
> returns a number of fields, with information on the status of the slave.
is
> there a way to only return the field(s) i'm interested in...
>
> i thought that i had figured this out, but i can't recall, and it's been
> awhile since i've played with this!
>
> thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=a...rthu@gmail.com
>
>

--
Sent from Gmail for mobile | mobile.google.com

Thanks
Alex
http://alexlurthu.wordpress.com

#4 (**permalink**) 02-28-2008, 07:02 AM

> mysql> show slave status
>
> returns a number of fields, with information on the status of the slave. is
> there a way to only return the field(s) i'm interested in...
>
> i thought that i had figured this out, but i can't recall, and it's been
> awhile since i've played with this!

My slave server isn't nearby, but...

show status like '%threads%';

will return just the results from "show status" that match on "threads".

Might work for slave status as well.

-philip

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode