http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Tue, 27 Dec 2016 16:45:41 +0000 en-US hourly 1 https://wordpress.org/?v=5.3.3 32412571 Why delegating code to MySQL Stored Routines is poor engineering practice https://shlomi-noach.github.io/blog/mysql/why-delegating-code-to-mysql-stored-routines-is-poor-engineering-practice https://shlomi-noach.github.io/blog/mysql/why-delegating-code-to-mysql-stored-routines-is-poor-engineering-practice#comments Thu, 06 Feb 2014 08:32:17 +0000 https://shlomi-noach.github.io/blog/?p=6713 https://shlomi-noach.github.io/blog/mysql/why-delegating-code-to-mysql-stored-routines-is-poor-engineering-practice/feed 11 6713 Converting an OLAP database to TokuDB, part 1 https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1 https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1#comments Tue, 03 Sep 2013 07:04:12 +0000 https://shlomi-noach.github.io/blog/?p=6473 https://shlomi-noach.github.io/blog/mysql/converting-an-olap-database-to-tokudb-part-1/feed 8 6473 common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params https://shlomi-noach.github.io/blog/mysql/common_schema-2-2-better-queryscript-isolation-tokudb-table_rotate-split-params https://shlomi-noach.github.io/blog/mysql/common_schema-2-2-better-queryscript-isolation-tokudb-table_rotate-split-params#comments Tue, 13 Aug 2013 03:39:12 +0000 https://shlomi-noach.github.io/blog/?p=6468 https://shlomi-noach.github.io/blog/mysql/common_schema-2-2-better-queryscript-isolation-tokudb-table_rotate-split-params/feed 1 6468 common_schema roadmap thoughts https://shlomi-noach.github.io/blog/mysql/common_schema-roadmap-thoughts https://shlomi-noach.github.io/blog/mysql/common_schema-roadmap-thoughts#comments Mon, 22 Jul 2013 12:36:08 +0000 https://shlomi-noach.github.io/blog/?p=6435 https://shlomi-noach.github.io/blog/mysql/common_schema-roadmap-thoughts/feed 4 6435 common_schema 2.1 released: advanced & improved split(), persistent script tables, more schema analysis, and (ahem) charts! https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts#comments Wed, 17 Jul 2013 18:57:06 +0000 https://shlomi-noach.github.io/blog/?p=6398 https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts/feed 4 6398 opeark-kit revision 196 released https://shlomi-noach.github.io/blog/mysql/opeark-kit-revision-196-released https://shlomi-noach.github.io/blog/mysql/opeark-kit-revision-196-released#respond Tue, 07 May 2013 05:47:22 +0000 https://shlomi-noach.github.io/blog/?p=6335 https://shlomi-noach.github.io/blog/mysql/opeark-kit-revision-196-released/feed 0 6335 common_schema: 1.3: security goodies, parameterized split(), json-to-xml, query checksum https://shlomi-noach.github.io/blog/mysql/common_schema-1-3-security-goodies-parameterized-split-json-to-xml-query-checksum https://shlomi-noach.github.io/blog/mysql/common_schema-1-3-security-goodies-parameterized-split-json-to-xml-query-checksum#respond Mon, 14 Jan 2013 06:25:07 +0000 https://shlomi-noach.github.io/blog/?p=5941 https://shlomi-noach.github.io/blog/mysql/common_schema-1-3-security-goodies-parameterized-split-json-to-xml-query-checksum/feed 0 5941 common_schema over traditional scripts https://shlomi-noach.github.io/blog/mysql/common_schema-over-traditional-scripts https://shlomi-noach.github.io/blog/mysql/common_schema-over-traditional-scripts#comments Wed, 12 Dec 2012 11:55:44 +0000 https://shlomi-noach.github.io/blog/?p=5509 https://shlomi-noach.github.io/blog/mysql/common_schema-over-traditional-scripts/feed 2 5509 Purging old rows with QueryScript: three use cases https://shlomi-noach.github.io/blog/mysql/purging-old-rows-with-queryscript-three-use-cases https://shlomi-noach.github.io/blog/mysql/purging-old-rows-with-queryscript-three-use-cases#respond Wed, 14 Nov 2012 09:15:35 +0000 https://shlomi-noach.github.io/blog/?p=5157 https://shlomi-noach.github.io/blog/mysql/purging-old-rows-with-queryscript-three-use-cases/feed 0 5157 common_schema 1.2: security, partition management, processes, QueryScript goodies https://shlomi-noach.github.io/blog/mysql/common_schema-1-2-security-partition-management-processes-queryscript-goodies https://shlomi-noach.github.io/blog/mysql/common_schema-1-2-security-partition-management-processes-queryscript-goodies#comments Tue, 13 Nov 2012 12:25:38 +0000 https://shlomi-noach.github.io/blog/?p=5539 https://shlomi-noach.github.io/blog/mysql/common_schema-1-2-security-partition-management-processes-queryscript-goodies/feed 2 5539