Comments on: Three wishes for a new year https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2 Blog by Shlomi Noach Sun, 02 Oct 2011 11:31:56 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53508 Sun, 02 Oct 2011 11:31:56 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53508 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)

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53191 Thu, 29 Sep 2011 05:58:36 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53191 @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.

]]> By: Robert Hodges https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53165 Thu, 29 Sep 2011 00:56:51 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53165 @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.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53133 Wed, 28 Sep 2011 14:52:22 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53133 @Robert,
Cool!
But this is beyond seconds_behind_master. I want to bypass I_S by using SHOW DATABASES, or SHOW CREATE TABLE etc.

]]> By: Robert Hodges https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53122 Wed, 28 Sep 2011 14:07:05 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53122 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

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53016 Tue, 27 Sep 2011 16:06:40 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53016 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…

]]> By: Matthew Montgomery https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53015 Tue, 27 Sep 2011 16:03:31 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53015 You mean you want https://launchpad.net/is-replication-status included in mainline.

]]> By: Cyril https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53014 Tue, 27 Sep 2011 14:54:41 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53014 Happy New Year !
שנה טובה !

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

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53013 Tue, 27 Sep 2011 14:41:44 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53013 @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.

]]> By: Jim Agnew https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year-2/comment-page-1#comment-53009 Tue, 27 Sep 2011 14:25:38 +0000 https://shlomi-noach.github.io/blog/?p=3996#comment-53009 Dear Shlomi, I finally did a Perl solution that is quite an awful hack, but it works… Interested?

]]>