{"id":6645,"date":"2013-11-04T17:30:50","date_gmt":"2013-11-04T15:30:50","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=6645"},"modified":"2013-11-15T18:20:48","modified_gmt":"2013-11-15T16:20:48","slug":"common_schema-speaking-at-percona-live-london-nov-2013","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/common_schema-speaking-at-percona-live-london-nov-2013","title":{"rendered":"common_schema: speaking at Percona Live London, Nov. 2013"},"content":{"rendered":"<p>In one week&#8217;s time I&#8217;ll be presenting <a href=\"http:\/\/www.percona.com\/live\/london-2013\/sessions\/commonschema-dbas-framework-mysql\">common_schema: DBA&#8217;s framework for MySQL<\/a> at Percona Live, London.<\/p>\n<p>This talk introduces the rich toolset known as <a href=\"http:\/\/code.google.com\/p\/common-schema\/\">common_schema<\/a>. It is free, open source, extremely useful in solving DBA &amp; developer tasks, and is the next best thing ever invented next to SQL pie charts.<\/p>\n<p>I&#8217;ll introduce:<\/p>\n<ul>\n<li>Views, with which you can detect and terminate idle transactions, blocking transactions; roll your range partitions; find duplicate keys; block\/unblock accounts; get fine grained privileges per account; find AUTO_ICNREMENT free space; &#8230;<\/li>\n<li>Routines: do meta executions such as eval(); get query checksums; duplicating accounts; killing suspicious connections; security auditing; parsing JSON data; &#8230;<\/li>\n<li>QueryScript: if you&#8217;re not using it, you&#8217;re missing on a powerful scripting language tightly integrated with SQL\/MySQL. We&#8217;ll see the basic constructs, variables, loops; the more sophisticated MySQL\/locks\/overhead\/danger aware constructs such as foreach &amp; split; throttling, exceptions, it&#8217;s all in there. I&#8217;ll present real scripts that saved the day and challenge you to implement them in another scripting language.<\/li>\n<li>Briefly introducing rdebug: stored routine debugger and debugging API<\/li>\n<li>Roadmap (some cool things coming along)<!--more--><\/li>\n<\/ul>\n<h4>What this talk isn&#8217;t<\/h4>\n<p>A tedious &#8220;read the manual aloud&#8221;. Nor is it a comprehensive listing of all functionality. These would be the surest way of sending you to sleep.<\/p>\n<h4>What this talk is<\/h4>\n<p>A view into the concepts behind <em>common_schema<\/em>; the reasons this project has justification to exist; the various problems it solves; and yes, interesting examples. Every single <em>common_schema<\/em> feature was developed out of real world need.<\/p>\n<p>I am confident you&#8217;ll find <em>common_schema<\/em> to have something you need that will improve your work as a developer or a DBA.<\/p>\n<p>The talk is similar to <a href=\"http:\/\/code.openark.org\/blog\/mysql\/speaking-at-percona-live-2013-common_schema-lightning-talks\">the one I gave<\/a> at Santa Clara this April. It is updated with new content following recent developments.<\/p>\n<p>&nbsp;<\/p>\n<p><iframe loading=\"lazy\" title=\"common_schema 2.2 DBA&#039;s framework for MySQL\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/b9W1uHzh9vrhqL\" width=\"427\" height=\"356\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/shlominoach\/commonschema-22\" title=\"common_schema 2.2 DBA&#39;s framework for MySQL\" target=\"_blank\">common_schema 2.2 DBA&#39;s framework for MySQL<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/shlominoach\" target=\"_blank\">Shlomi Noach<\/a><\/strong> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>In one week&#8217;s time I&#8217;ll be presenting common_schema: DBA&#8217;s framework for MySQL at Percona Live, London. This talk introduces the rich toolset known as common_schema. It is free, open source, extremely useful in solving DBA &amp; developer tasks, and is the next best thing ever invented next to SQL pie charts. I&#8217;ll introduce: Views, with [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[67,90,70],"class_list":["post-6645","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-common_schema","tag-perconalive","tag-speaking"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1Jb","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=6645"}],"version-history":[{"count":6,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6645\/revisions"}],"predecessor-version":[{"id":6662,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6645\/revisions\/6662"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=6645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=6645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=6645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}