http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Wed, 14 Nov 2012 09:20:08 +0000 en-US hourly 1 https://wordpress.org/?v=5.3.3 32412571 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 How common_schema split()s tables – internals https://shlomi-noach.github.io/blog/mysql/how-common_schema-splits-tables-internals https://shlomi-noach.github.io/blog/mysql/how-common_schema-splits-tables-internals#comments Thu, 06 Sep 2012 05:25:07 +0000 https://shlomi-noach.github.io/blog/?p=5035 https://shlomi-noach.github.io/blog/mysql/how-common_schema-splits-tables-internals/feed 5 5035 Table split(…) for the masses https://shlomi-noach.github.io/blog/mysql/table-split-for-the-masses https://shlomi-noach.github.io/blog/mysql/table-split-for-the-masses#respond Wed, 05 Sep 2012 05:04:05 +0000 https://shlomi-noach.github.io/blog/?p=5034 https://shlomi-noach.github.io/blog/mysql/table-split-for-the-masses/feed 0 5034 common_schema rev. 68: eval(), processlist_grantees, candidate_keys, easter_day() https://shlomi-noach.github.io/blog/mysql/common_schema-rev-68-eval-processlist_grantees-candidate_keys-easter_day https://shlomi-noach.github.io/blog/mysql/common_schema-rev-68-eval-processlist_grantees-candidate_keys-easter_day#respond Tue, 06 Sep 2011 07:05:34 +0000 https://shlomi-noach.github.io/blog/?p=3952 https://shlomi-noach.github.io/blog/mysql/common_schema-rev-68-eval-processlist_grantees-candidate_keys-easter_day/feed 0 3952 Announcing common_schema: common views & routines for MySQL https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql#comments Wed, 13 Jul 2011 04:25:24 +0000 https://shlomi-noach.github.io/blog/?p=3794 https://shlomi-noach.github.io/blog/mysql/announcing-common_schema-common-views-routines-for-mysql/feed 7 3794 Reasons to use AUTO_INCREMENT columns on InnoDB https://shlomi-noach.github.io/blog/mysql/reasons-to-use-auto_increment-columns-on-innodb https://shlomi-noach.github.io/blog/mysql/reasons-to-use-auto_increment-columns-on-innodb#comments Tue, 22 Mar 2011 06:31:18 +0000 https://shlomi-noach.github.io/blog/?p=3196 https://shlomi-noach.github.io/blog/mysql/reasons-to-use-auto_increment-columns-on-innodb/feed 9 3196 Multi condition UPDATE query https://shlomi-noach.github.io/blog/mysql/multi-condition-update-query https://shlomi-noach.github.io/blog/mysql/multi-condition-update-query#comments Thu, 27 Jan 2011 08:30:24 +0000 https://shlomi-noach.github.io/blog/?p=2401 https://shlomi-noach.github.io/blog/mysql/multi-condition-update-query/feed 8 2401 Simple guideline for choosing appropriate InnoDB PRIMARY KEYs https://shlomi-noach.github.io/blog/mysql/simple-guideline-for-choosing-appropriate-innodb-primary-keys https://shlomi-noach.github.io/blog/mysql/simple-guideline-for-choosing-appropriate-innodb-primary-keys#comments Thu, 21 Oct 2010 05:52:45 +0000 https://shlomi-noach.github.io/blog/?p=2104 https://shlomi-noach.github.io/blog/mysql/simple-guideline-for-choosing-appropriate-innodb-primary-keys/feed 1 2104 Thoughts and ideas for Online Schema Change https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change#comments Thu, 07 Oct 2010 08:29:10 +0000 https://shlomi-noach.github.io/blog/?p=3005 https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/feed 8 3005 How often should you use OPTIMIZE TABLE? – followup https://shlomi-noach.github.io/blog/mysql/how-often-should-you-use-optimize-table-followup https://shlomi-noach.github.io/blog/mysql/how-often-should-you-use-optimize-table-followup#comments Mon, 04 Oct 2010 08:07:45 +0000 https://shlomi-noach.github.io/blog/?p=2882 https://shlomi-noach.github.io/blog/mysql/how-often-should-you-use-optimize-table-followup/feed 7 2882