Comments on: Announcing common_schema: common views & routines for MySQL https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql Blog by Shlomi Noach Wed, 20 Jul 2011 14:27:20 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: common_schema: looking for contributions | code.openark.org https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-46528 Wed, 20 Jul 2011 14:27:20 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-46528 […] Announcing common_schema: common views & routines for MySQL […]

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-46013 Wed, 13 Jul 2011 12:52:35 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-46013 Oh, there’s also the easter day function, but it didn’t seem to fit directly in the categories you provide.

http://forge.mysql.com/tools/tool.php?id=250

(maybe date/time functions?)

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-46012 Wed, 13 Jul 2011 12:50:55 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-46012 Hi Shlomi, here’s a bunch:

mysqldump_partition_backup: generate partition-wise mysqldump commands
http://forge.mysql.com/tools/tool.php?id=258

Obtain the original code for a MySQL view.
http://forge.mysql.com/tools/tool.php?id=246

Creating FEDERATED tables with a stored procedure:
http://forge.mysql.com/tools/tool.php?id=54

Check for violated foreign key constraints
http://forge.mysql.com/tools/tool.php?id=11

Redundant Index Finder
http://forge.mysql.com/tools/tool.php?id=45

(I know you already have a redundant index findex, but this one sports a couple of views to report sane index info that you may find interesting)

Feel free to check it out, and drop me a line if you have a question or need me to fix or modify something.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-46009 Wed, 13 Jul 2011 12:12:10 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-46009 @Jonathan,
thanks!
(and… congrads? new job?)

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-46008 Wed, 13 Jul 2011 12:11:57 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-46008 @Roland,
Oh, absolutely! I’m looking for contributions, but have failed to mention that. I recall quite a few snippets you wrote at the time; I’d love to have another look.
Let me formalize to myself the criteria for snippets to be in common_schema (licenses aside). Meanwhile, why don’t you send me links to those procs?

]]> By: Jonathan Levin https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-45993 Wed, 13 Jul 2011 08:23:29 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-45993 Hey Shlomi

Great idea and great toolkit!

Best Regards
Jonathan

]]> By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/comment-page-1#comment-45989 Wed, 13 Jul 2011 07:36:15 +0000 https://shlomi-noach.github.io/blog/?p=3794#comment-45989 Hi Shlomi!

great work, looks like a useful toolbox. There’s a few snippets I posted in the way back years to the mysql forge that might be interesting for you. I was thinking about the proc that checks for foreign key violations (to check integrity after disabling foreign key checks) and a proc to create federated tables. I see you already have a redundant key checker.

If you feel like integrating those, drop me a line. If not, that’s ok too.

kind regards,
Roland

]]>