'MySQL' Category

• mycheckpoint revision 231 released

  May 23, 2013

  A new release for mycheckpoint: lightweight, SQL oriented MySQL monitoring solution. If you're unfamiliar with mycheckpoint, well, the one minute sales pitch is: it's a free and open source monitoring tool for MySQL, which is extremely easy to install and execute, and which includes custom queries, alerts (via emails), and out of the box HTTP [...]

  posted in MySQL by shlomi

• opeark-kit revision 196 released

  May 7, 2013

  This is a long due maintenance release of openark-kit. This release includes bugfixes and some enhancements, mainly to oak-online-alter-table. oak-online-alter-table Changes / bug fixes include: Support for keyword-named columns Use of FORCE INDEX due to lack of MySQL's ability for figure out the chunking key at all times --sleep-ratio option added; allows for sleep time [...]

  posted in MySQL by shlomi

• On compiling TokuDB from source

  May 2, 2013

  Sharing my experience of compiling TokuDB + MariaDB 5.5. Why? Because I must have this patch to Sphinx 2.0.4. Note: I was using what seems to be the "old" method of compiling; quoting Leif Walsh: ... We are looking at deprecating that method of building (MariaDB source plus binary fractal tree handlerton).  It only really [...]

  posted in MySQL by shlomi

• Percona Live 2013 keynotes: followup questions and discussion

  April 28, 2013

  Here are a few questions remained open for me from Percona Live 2013 about things that have been said during keynotes; I will appreciate a discussion on comments. Here goes: Question #1 Brian Aker (HP) asks Simone Brunozzi (Amazon) what the underlying technology for DynamoDB is. Simone says can't disclose. Brian says: "it's MySQL!!". Simone [...]

  posted in MySQL by shlomi

• common_schema booth on Percona Live 2013

  April 27, 2013

  Yay! I got a booth! I confess it was mostly deserted. My hero Allen Kinnard, whom I've never met before, was kind enough to volunteer to occupy the booth. So between him and me, both of course also looking to visit other booths and talk to people, the common_schema booth was only moderately attended. Well, [...]

  posted in MySQL by shlomi

• Slides from my talk: common_schema, DBA's Framework for MySQL

  April 26, 2013

  I've just uploaded the slides from my talk: common_schema: DBA's framework for MySQL My talk was well attended, and I was fortunate to have a warm and engaged audience. Thank you to all those who attended, and thank you for those who provided feedback! Was happy to be able to present my work a great group [...]

  posted in MySQL by shlomi

• Impressions from Percona Live 2013

  April 26, 2013

  At the airport, trying to sum up my impressions from Percona Live 2013 conference in Santa Clara. Woo! Hard to sum up four excellent days. Shall I review the great talks I've been to? The keynotes? The well organized events? You know what, skip it. There was ONE thing that overshadowed everything. It was the [...]

  posted in MySQL by shlomi

• Speaking at Percona Live 2013: common_schema, lightning talks

  April 11, 2013

  In two weeks time I will be giving these talks at Percona Live: common_schema: DBA's framework for MySQL: an introduction to common_schema, my evolving server side solutions project. This will be a revised version of the talk I gave at Percona Live London; I have felt some weaknesses during that talk, which I've thrown out, [...]

  posted in MySQL by shlomi

• Taking common_schema's rdebug to a test-drive

  April 9, 2013

  This is a simple step-by-step introduction to rdebug: Debugger and Debugging API for MySQL Stored Routines, as part of common_schema. In other words: let me take you through the steps for debugging your stored routines on your own server. We will step into, step over, step out, modify variables, set a breakpoint, run to breakpoint... [...]

  posted in MySQL by shlomi

• common_schema 2.0.0-alpha: rdebug, GPL

  April 9, 2013

  A new release for common_schema: an alpha version of rdebug: MySQL Debugger and Debugging API is now included with common_schema. With a different license in mind for rdebug, common_schema changes license to GPL (2 or above). common_schema 2.0 is ready for download. All things rdebug, it is alpha -- otherwise it's a stable release. rdebug [...]

  posted in MySQL by shlomi