http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Mon, 10 Oct 2011 05:48:10 +0000 en-US hourly 1 https://wordpress.org/?v=5.3.3 32412571 Speaking on Percona Live, London: “Programmatic Queries: things you can code with SQL” https://shlomi-noach.github.io/blog/mysql/speaking-on-percona-live-london-programmatic-queries-things-you-can-code-with-sql https://shlomi-noach.github.io/blog/mysql/speaking-on-percona-live-london-programmatic-queries-things-you-can-code-with-sql#comments Mon, 10 Oct 2011 05:48:10 +0000 https://shlomi-noach.github.io/blog/?p=4043 https://shlomi-noach.github.io/blog/mysql/speaking-on-percona-live-london-programmatic-queries-things-you-can-code-with-sql/feed 2 4043 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 EXPLAIN: missing db info https://shlomi-noach.github.io/blog/mysql/explain-missing-db-info https://shlomi-noach.github.io/blog/mysql/explain-missing-db-info#comments Tue, 11 May 2010 04:57:02 +0000 https://shlomi-noach.github.io/blog/?p=2368 https://shlomi-noach.github.io/blog/mysql/explain-missing-db-info/feed 13 2368 Things to monitor on MySQL, the user’s perspective https://shlomi-noach.github.io/blog/mysql/things-to-monitor-on-mysql-the-users-perspective https://shlomi-noach.github.io/blog/mysql/things-to-monitor-on-mysql-the-users-perspective#comments Wed, 10 Mar 2010 09:12:24 +0000 https://shlomi-noach.github.io/blog/?p=2008 https://shlomi-noach.github.io/blog/mysql/things-to-monitor-on-mysql-the-users-perspective/feed 2 2008 SQL: Ranking without self join https://shlomi-noach.github.io/blog/mysql/sql-ranking-without-self-join https://shlomi-noach.github.io/blog/mysql/sql-ranking-without-self-join#comments Mon, 14 Sep 2009 16:16:11 +0000 https://shlomi-noach.github.io/blog/?p=1293 https://shlomi-noach.github.io/blog/mysql/sql-ranking-without-self-join/feed 35 1293 7 ways to convince MySQL to use the right index https://shlomi-noach.github.io/blog/mysql/7-ways-to-convince-mysql-to-use-the-right-index https://shlomi-noach.github.io/blog/mysql/7-ways-to-convince-mysql-to-use-the-right-index#comments Thu, 02 Apr 2009 16:06:32 +0000 https://shlomi-noach.github.io/blog/?p=695 https://shlomi-noach.github.io/blog/mysql/7-ways-to-convince-mysql-to-use-the-right-index/feed 39 695 Two storage engines; different plans, Part II https://shlomi-noach.github.io/blog/mysql/two-storage-engines-different-plans-part-ii https://shlomi-noach.github.io/blog/mysql/two-storage-engines-different-plans-part-ii#comments Fri, 07 Nov 2008 17:55:08 +0000 https://shlomi-noach.github.io/blog/?p=35 https://shlomi-noach.github.io/blog/mysql/two-storage-engines-different-plans-part-ii/feed 3 35 Two storage engines; different plans, Part I https://shlomi-noach.github.io/blog/mysql/two-storage-engines-different-plans-part-i https://shlomi-noach.github.io/blog/mysql/two-storage-engines-different-plans-part-i#comments Sat, 01 Nov 2008 16:36:29 +0000 https://shlomi-noach.github.io/blog/?p=9 https://shlomi-noach.github.io/blog/mysql/two-storage-engines-different-plans-part-i/feed 2 9