'common_schema' Tag

  • Get per-object grants via common_schema

    September 29, 2014

    Did you know common_schema supports a complete breakdown of all accounts on your database server? It can provide you with the GRANT statements required to set up an account, the REVOKE statements to undo the former, and this can be broken down on a per-object & per-object-type basis. Consider the sql_grants view: Find who has […]

  • Speaking at Percona Live: common_schema, MySQL DevOps

    March 10, 2014

    In less than a month I'll be giving these two talks at Percona Live: common_schema: DBA's framework for MySQL If you are still unfamiliar with common_schema, this will make for a good introduction. I'll give you multiple reasons why you would want to use it, and how it would come to immediate use at your […]

  • Why delegating code to MySQL Stored Routines is poor engineering practice

    February 6, 2014

    I happen to use stored routines with MySQL. In fact, my open source project common_schema heavily utilizes them. DBA-wise, I think they provide with a lot of power (alas, the ANSI:SQL 2003 syntax feels more like COBOL than a sane programming language, which is why I use QueryScript instead). However I wish to discuss the […]

  • common_schema: speaking at Percona Live London, Nov. 2013

    November 4, 2013

    In one week's time I'll be presenting common_schema: DBA'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 & developer tasks, and is the next best thing ever invented next to SQL pie charts. I'll introduce: Views, with […]

  • Converting an OLAP database to TokuDB, part 3: operational stuff

    October 14, 2013

    This is the third post in a series of posts describing our experience in migrating a large DWH server to TokuDB (see 1st and 2nd parts). This post discusses operations; namely ALTER TABLE operations in TokuDB. We ran into quite a few use cases by this time that we can shed light on. Quick recap: […]

  • Converting an OLAP database to TokuDB, part 2: the process of migration

    September 9, 2013

    This is a second in a series of posts describing our experience in migrating a large DWH server to TokuDB. This post discusses the process of migration itself. As a quick recap (read part 1 here), we have a 2TB compressed InnoDB (4TB uncompressed) based DWH server. Space is running low, and we're looking at […]

  • Converting an OLAP database to TokuDB, part 1

    September 3, 2013

    This is the first in a series of posts describing my impressions of converting a large OLAP server to TokuDB. There's a lot to tell, and the experiment is not yet complete, so this is an ongoing blogging. In this post I will describe the case at hand and out initial reasons for looking at […]

  • common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params

    August 13, 2013

    common_schema 2.2 is released. This is shortly after the 2.1 release; it was only meant as bug fixes release but some interesting things came up, leading to new functionality. Highlights of the 2.2 release: Better QueryScript isolation & cleanup: isolation improved across replication topology, cleanup done even on error Added TokuDB related views split with […]

  • common_schema roadmap thoughts

    July 22, 2013

    I'm happy with common_schema; it is in fact a tool I use myself on an almost daily basis. I'm also happy to see that it gains traction; which is why I'm exposing a little bit of my thoughts on general future development. I'd love to get feedback. Supported versions At this moment, common_schema supports MySQL […]

  • common_schema 2.1 released: advanced & improved split(), persistent script tables, more schema analysis, and (ahem) charts!

    July 17, 2013

    common_schema 2.1 is released! common_schema is your free & open source companion schema within your MySQL server, providing with a function library, scripting capabilities, powerful routines and ready-to-apply information and recommendations. New and noteworthy in version 2.1: Better QueryScript's split() functionality Persistent tables for QueryScript: no long held temporary tables Index creation analysis, further range […]

 
Powered by Wordpress and MySQL. Theme by openark.org