'QueryScript' 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: 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 over traditional scripts

  December 12, 2012

  If you are familiar with both openark kit and common_schema, you'll notice I've incorporated some functionality already working in openark kit into common_schema, essentially rewriting what used to be a Python script into SQL/QueryScript. What was my reasoning for rewriting good code? I wish to explain that, and provide with a couple examples. I'm generally [...]

  posted in MySQL by shlomi

• Purging old rows with QueryScript: three use cases

  November 14, 2012

  Problem: you need to purge old rows from a table. This may be your weekly/monthly cleanup task. The table is large, the amount of rows to be deleted is large, and doing so in one big DELETE is too heavy. You can use oak-chunk-update or pt-archiver to accomplish the task. You can also use server [...]

  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

• How common_schema installs itself

  September 11, 2012

  Up till common_schema version 1.1, the user would need to choose from distinct distribution files: an install compatible with MySQL 5.1, one compatible with InnoDB Plugin enabled servers, and one compatible with Percona Server. The difference between the three is the availability of certain INFORMATION_SCHEMA tables. With 1.1, this is no longer the case: common_schema [...]

  posted in MySQL by shlomi

• How common_schema split()s tables - internals

  September 6, 2012

  This post exposes some of the internals, and the SQL behind QueryScript's split. common_schema/QueryScript 1.1 introduces the split statement, which auto-breaks a "large" query (one which operates on large tables as a whole or without keys) into smaller queries, and executes them in sequence. This makes for easier transactions, less locks held, potentially (depending on [...]

  posted in MySQL by shlomi

• Table split(...) for the masses

  September 5, 2012

  (pun intended) common_schema's new split statement (see release announcement) auto-splits complex queries over large tables into smaller ones: instead of issuing one huge query, split breaks one's query into smaller queries, each working on a different set of rows (a chunk). Thus, it is possible to avoid holding locks for long times, allowing for smaller [...]

  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

• DELETE, don't INSERT

  June 27, 2012

  Have just read INSERT, Don’t DELETE by Aaron Brown, and have some lengthy response, which is why I write this post instead of commenting on said post. I wish to offer my counter thought and suggest that DELETEs are probably the better choice. Aaron suggests that, when one wishes to purge rows from some table, [...]

  posted in MySQL by shlomi