Skip to content

# Three wishes for a new year

MySQL SQL September 27, 2011

It’s another new year by Jewish calendar. And what do I wish for in the following year?

1. World peace
2. Good health to all
3. Have some way to turn SHOW commands into SELECT statements, server side. I’m fervently trying to hack around this. Stored routines, export/import from file, text manipulation, I don’t care! I want to SELECT seconds_behind_master somehow. Without plugins.

PS, none of my last year’s wishes came true. I’ll settle for two out of three.

- Twitter
- LinkedIn
- WhatsApp
- Email
- Facebook
- Print

###
10
Leave a Reply

8 Comment threads
2 Thread replies
0 Followers
Most reacted comment
Hottest comment thread
5 Comment authors
Recent comment authors

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe
Notify of
Guest
Jim Agnew

Dear Shlomi, I finally did a Perl solution that is quite an awful hack, but it works… Interested?

Author
shlomi

@Jim,
Thanks, however I’m looking for a server side solution: from within the mysql server itself. Or have you managed to somehow invoke perl from the server?
I don’t mind the least about ugly solutions. Anything can be wrapped to present well.

Guest
Cyril

Happy New Year !
שנה טובה !

Hope this will be a great new year for all dba 🙂

Guest
Matthew Montgomery

You mean you want https://launchpad.net/is-replication-status included in mainline.

Author
shlomi

Yes, but automatically, and for ANY “show” command.
I’m aware of this why-didn’t-they-think-of-this plugin, have wondered why this was not imported into the baseline…

Guest
Robert Hodges

Hi Shlomi! Happy new year. Why don’t you just switch to Tungsten? Then you can select the seconds behind as follows:

select applied_latency as “seconds behind” from trep_commit_seqno

Author
shlomi

@Robert,
Cool!
But this is beyond seconds_behind_master. I want to bypass I_S by using SHOW DATABASES, or SHOW CREATE TABLE etc.

Guest
Robert Hodges

@Shlomi. Aw, I was just trying to be helpful! 🙂 However, I see what you mean. This seems to be another case of the “SQL is not quite a real language” problem.

Author
shlomi

@Robert,
Guilty as charged. Although I’m not trying to build a Python interpreter in SQL, I am trying to provide some handy syntax for complex operations.

Author
shlomi

YES!
I have found a magnificent way of reading results of (some) SHOW commands on server side. Unfortunately, the solution is too large to be contained in this comment.

Alas, it does not include SHOW SLAVE STATUS, SHOW MASTER STATUS and the like.
I will publish separately.
(this is not a joke)

wpDiscuz
Send to Email Address Your Name Your Email Address Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.