'Open Source' Tag

• 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

• 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

• Assistance wanted: DotOrg Pavilion on Percona Live 2013

  April 2, 2013

  I'm looking for assistance in manning a DotOrg Pavilion on the upcoming Percona Live conference in Santa Clara. As you may or may not know, free and open source projects are eligible to ask for a free booth on the Expo hall. This is a good chance to promote one's project. Of course, someone must [...]

  posted in MySQL by shlomi

• Re: MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation

  January 24, 2013

  Reading Sheeri's MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation, I was baffled at this change of floating point number notation. However, I was also concerned about the final action taken: using "--ignore-columns" to avoid comparing the FLOAT/DOUBLE types. The --float-precision option for pt-table-checksum currently only uses ROUND() so as to disregard minor [...]

  posted in MySQL by shlomi

• common_schema: 1.3: security goodies, parameterized split(), json-to-xml, query checksum

  January 14, 2013

  common_schema 1.3 is released and is available for download. New and noteworthy in this version: Parameterized split(): take further control over huge transactions by breaking them down into smaller chunks, now manually tunable if needed duplicate_grantee(): copy+paste existing accounts along with their full set of privileges similar_grants: find which accounts share the exact same set [...]

  posted in MySQL by shlomi

• common_schema 1.2: security, partition management, processes, QueryScript goodies

  November 13, 2012

  common_schema 1.2 is released! This version comes shortly after 1.1, yet contains quite a few interesting goodies: Account blocking Security audit RANGE partition management Slave status Better blocking and idle transaction management QueryScript goodies: echo, report while-otherwise statement; foreach-otherwise statement Better variable scope handling Complete support for variable expansion Transaction support within QueryScript More summary [...]

  posted in MySQL by shlomi

• common_schema 1.1 released: split(), try-catch, killall(), profiling

  September 4, 2012

  I'm very happy to announce the release of common_schema, version 1.1 (revision 300). This version boasts with compelling new features: innovative QueryScript syntax, libraries, views which add to your skills as a DBA, making some maintenance and management tasks a breeze. QueryScript, split statement: automagically break long queries into smaller chunks, avoid long locks and [...]

  posted in MySQL by shlomi

• sphinx, sphinx_snippets() & MySQL 5.5

  March 21, 2012

  I've written a patch which completes Sphinx's integration with MySQL 5.5. Up until a couple months ago, Sphinx would not compile with MySQL 5.5 at all. This is, thankfully, resolved as of Sphinx 2.0.3. However, to my disdain, I've found out that it only partially work: the sphinx_snippets() user defined function is not included within [...]

  posted in MySQL by shlomi

• common_schema rev. 218: QueryScript, throttling, processes, documentation

  February 8, 2012

  common_schema, revision 218 is released, with major new features, top one being server side scripting. Here are the highlights: QueryScript: server side scripting is now supported by common_schema, which acts as an interpreter for QueryScript code. Throttling for queries is now made available via the throttle() function. Enhancements to processlist-related views, including the new slave_hosts [...]

  posted in MySQL by shlomi