'Development' Tag

• 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

• 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.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

• QueryScript: SQL scripting language

  February 8, 2012

  Introducing QueryScript: a programming language aimed for SQL scripting, seamlessly combining scripting power such as flow control & variables with standard SQL statements or RDBMS-specific commands. QueryScript is available fro MySQL via common_schema, which adds MySQL-specific usage. What does QueryScript look like? Here are a few code samples: Turn a bulk DELETE operation into smaller [...]

  posted in MySQL by shlomi

• Oracle "Technologist of the Year: Developer" Award

  December 21, 2011

  I am honored to receive Oracle's Technologist of the Year: Developer award, formerly Oracle Magazine Editors’ Choice Awards. Technologist of the Year Award is given for individuals for their technical achievements with regard to Oracle products. As opposed to community based awards, to win this award one must be nominated by himself or his company. [...]

  posted in MySQL by shlomi

• common_schema, rev. 178: foreach(), repeat_exec(), Roland Bouman, query analysis

  December 1, 2011

  common_schema, revision 178 is now released, with major additions. This revision turns common_schema into a framework, rather than a set of views and functions. common_schema provides with query scripting, analysis & informational views, and a function library, allowing for easier administration and diagnostics for MySQL. It introduces SQL based tools which simplify otherwise complex shell [...]

  posted in MySQL by shlomi

• Test-driven SQL development

  October 20, 2011

  I'm having a lot of fun writing common_schema, an SQL project which includes views, tables and stored routines. As the project grows (and it's taking some interesting directions, in my opinion) more dependencies are being introduced, and a change to one routine or view may affect many others. This is why I've turned the development [...]

  posted in Development, MySQL by shlomi