It’s another new year by Jewish calendar. And what do I wish for in the following year?
- World peace
- Good health to all
- 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.
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
@Robert,
Cool!
But this is beyond seconds_behind_master. I want to bypass I_S by using SHOW DATABASES, or SHOW CREATE TABLE etc.
@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.
@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.
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)