Comments on: Reading results of SHOW statements, on server side https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side Blog by Shlomi Noach Wed, 18 Jul 2012 04:45:31 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: MySQL error handling on server side: a NO GO! | code.openark.org https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-107972 Wed, 18 Jul 2012 04:45:31 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-107972 […] Reading results of SHOW statements, on server side […]

]]> By: More MySQL foreach() | code.openark.org https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-61325 Fri, 02 Dec 2011 13:56:53 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-61325 […] Reading results of SHOW statements, on server side […]

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60672 Mon, 28 Nov 2011 00:40:44 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60672 I think we did somehow talk about it in the context of user defined variables. That was apparently enough for Baron’s braingears.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60455 Sat, 26 Nov 2011 10:36:28 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60455 @Peter,
Easier — yes! Also more correct to do so. But I have recently crashed a production server (my own one, a slave) by querying INFORMATION_SCHEMA. In openark-kit tools I’ve added options to tell the tools some meta-info rather than let them find it out themselves, because the lockdown they would incur by querying INFORMATION_SCHEMA was measures in *minutes*.

anyway, like I said, I’ve found a wonderful solution for that. Unfortunately, this comment is too small for me to put it in writing. I’ll blog separately.

]]> By: Peter Laursen https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60449 Sat, 26 Nov 2011 08:42:51 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60449 Good catch indeed, but wasn’t it easier to “SELECT .. FROM information_schema …” after all?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60376 Fri, 25 Nov 2011 19:47:56 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60376 @Baron,
I did not hint at it, my memory serves me right; Roland is my witness. Any further disagreement on your side will be moderated 😉

]]> By: Baron Schwartz https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60375 Fri, 25 Nov 2011 19:43:22 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60375 It wasn’t quite that simple for me to guess the solution… you hinted at it somehow, if I recall 🙂

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60336 Fri, 25 Nov 2011 12:52:23 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60336 Brilliant hack!

Indeed, very humbling to see it took Baron just seconds to guess how to make it work…But IMO, that’s just more proof of his intellect and MySQL expertise, it doesn’t make your hack less brilliant.

Cheers, and kudos 🙂

Roland.

]]> By: Log Buffer #247, A Carnival of the Vanities for DBAs | The Pythian Blog https://shlomi-noach.github.io/blog/mysql/reading-results-of-show-statements-on-server-side/comment-page-1#comment-60312 Fri, 25 Nov 2011 07:02:06 +0000 https://shlomi-noach.github.io/blog/?p=4138#comment-60312 […] Shlomi Noach blogs about reading results of SHOW statements, on server side. […]

]]>