Three wishes for a new year

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.

10 thoughts on “Three wishes for a new year

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

  2. @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.

  3. 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…

Leave a Reply

Your email address will not be published. Required fields are marked *

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