http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Mon, 01 Aug 2016 17:19:00 +0000 en-US hourly 1 https://wordpress.org/?v=5.3.3 32412571 Introducing gh-ost: triggerless online schema migrations https://shlomi-noach.github.io/blog/mysql/introducing-gh-ost-triggerless-online-schema-migrations https://shlomi-noach.github.io/blog/mysql/introducing-gh-ost-triggerless-online-schema-migrations#comments Mon, 01 Aug 2016 17:19:00 +0000 https://shlomi-noach.github.io/blog/?p=7596 https://shlomi-noach.github.io/blog/mysql/introducing-gh-ost-triggerless-online-schema-migrations/feed 1 7596 The mystery of MySQL 5.6 excessive buffer pool flushing https://shlomi-noach.github.io/blog/mysql/the-mystery-of-mysql-5-6-excessive-buffer-pool-flushing https://shlomi-noach.github.io/blog/mysql/the-mystery-of-mysql-5-6-excessive-buffer-pool-flushing#comments Sun, 20 Apr 2014 05:16:13 +0000 https://shlomi-noach.github.io/blog/?p=6843 https://shlomi-noach.github.io/blog/mysql/the-mystery-of-mysql-5-6-excessive-buffer-pool-flushing/feed 15 6843 TokuDB configuration variables of interest https://shlomi-noach.github.io/blog/mysql/tokudb-configuration-variables-of-interest https://shlomi-noach.github.io/blog/mysql/tokudb-configuration-variables-of-interest#comments Wed, 23 Oct 2013 17:42:12 +0000 https://shlomi-noach.github.io/blog/?p=6613 https://shlomi-noach.github.io/blog/mysql/tokudb-configuration-variables-of-interest/feed 14 6613 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 DELETE, don’t INSERT https://shlomi-noach.github.io/blog/mysql/delete-dont-insert https://shlomi-noach.github.io/blog/mysql/delete-dont-insert#comments Wed, 27 Jun 2012 05:25:09 +0000 https://shlomi-noach.github.io/blog/?p=5008 https://shlomi-noach.github.io/blog/mysql/delete-dont-insert/feed 6 5008 Self throttling MySQL queries https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries#comments Tue, 01 Nov 2011 07:55:47 +0000 https://shlomi-noach.github.io/blog/?p=4294 https://shlomi-noach.github.io/blog/mysql/self-throttling-mysql-queries/feed 5 4294 On generating unique IDs using LAST_INSERT_ID() and other tools https://shlomi-noach.github.io/blog/mysql/on-generating-unique-ids-using-last_insert_id-and-other-tools https://shlomi-noach.github.io/blog/mysql/on-generating-unique-ids-using-last_insert_id-and-other-tools#comments Wed, 02 Feb 2011 06:50:02 +0000 https://shlomi-noach.github.io/blog/?p=3283 https://shlomi-noach.github.io/blog/mysql/on-generating-unique-ids-using-last_insert_id-and-other-tools/feed 7 3283 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 Views: better performance with condition pushdown https://shlomi-noach.github.io/blog/mysql/views-better-performance-with-condition-pushdown https://shlomi-noach.github.io/blog/mysql/views-better-performance-with-condition-pushdown#comments Thu, 20 May 2010 05:17:05 +0000 https://shlomi-noach.github.io/blog/?p=1328 https://shlomi-noach.github.io/blog/mysql/views-better-performance-with-condition-pushdown/feed 1 1328 Reducing locks by narrowing primary key https://shlomi-noach.github.io/blog/mysql/reducing-locks-by-narrowing-primary-key https://shlomi-noach.github.io/blog/mysql/reducing-locks-by-narrowing-primary-key#comments Tue, 04 May 2010 06:46:01 +0000 https://shlomi-noach.github.io/blog/?p=1269 https://shlomi-noach.github.io/blog/mysql/reducing-locks-by-narrowing-primary-key/feed 7 1269