Comments on: common_schema: looking for contributions https://shlomi-noach.github.io/blog/mysql/common_schema-looking-for-contributions Blog by Shlomi Noach Thu, 21 Jul 2011 05:48:29 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/common_schema-looking-for-contributions/comment-page-1#comment-46584 Thu, 21 Jul 2011 05:48:29 +0000 https://shlomi-noach.github.io/blog/?p=3837#comment-46584 @Matthew,

can you please refer to the question on:
http://code.google.com/p/common-schema/issues/detail?id=2?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/common_schema-looking-for-contributions/comment-page-1#comment-46578 Thu, 21 Jul 2011 04:44:49 +0000 https://shlomi-noach.github.io/blog/?p=3837#comment-46578 @Matthew,

Cool! I recall your initial post on this.
If this is OK with you, I will start with a modified code: a view which provides those SQL statements to kill slow queries. This is to be consistent with other sql-generation views.
After that, one can throw the SQL statement to whatever procedure you like.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/common_schema-looking-for-contributions/comment-page-1#comment-46577 Thu, 21 Jul 2011 04:39:54 +0000 https://shlomi-noach.github.io/blog/?p=3837#comment-46577 @Daniel,
Thanks! Not sure this will fit in with common_schema; also, I already manage a monitoring tool for mysql: mycheckpoint. To be honest, I’m not sure I will find the energy to work on another one 🙂

However I’ll be happy to take a look. Is this project hosted in a public location?

]]> By: Matthew Montgomery https://shlomi-noach.github.io/blog/mysql/common_schema-looking-for-contributions/comment-page-1#comment-46549 Wed, 20 Jul 2011 18:52:04 +0000 https://shlomi-noach.github.io/blog/?p=3837#comment-46549 Any interest in adding? http://forge.mysql.com/tools/tool.php?id=106

]]> By: Daniel https://shlomi-noach.github.io/blog/mysql/common_schema-looking-for-contributions/comment-page-1#comment-46542 Wed, 20 Jul 2011 17:43:14 +0000 https://shlomi-noach.github.io/blog/?p=3837#comment-46542 I have put up a similar common database for monitoring purpose, capturing Records, Data and Index sizes once per day — or changable through modification of event timing — with help of events, functions and procedures (all MySQL native, no external programs needed, everything OS independent).
If you’re interested in evaluating such structure to integrate it here, let me know!
Or we can collaborate to a similar project but focused on native MySQL monitoring project.

]]>