SQL25-09 MariaDB’s Query Optimizer. A Multi-tool That Does Some Things Differently (Monty Widenius)
SQL25-09 MariaDB’s Query Optimizer. A Multi-tool That Does Some Things Differently (Monty Widenius) 00:00 Start 00:09 Вступление 02:24 History 07:19 MariaDB's Query Optimizer 10:55 Architecture 11:55 Optimizer overview 13:05 Subquery optimizations plan 14:14 Constant tables 17:15 Range Optimizer 17:31 Range Analyzer 24:03 Range analyser output 24:26 Range analyser output (много условий) 25:40 The optimizer trace 27:01 Handling for special cases 30:35 Optimizer cost 30:48 Optimizer redesign in MariaDB 11.0 36:43 Different storage engine costs 38:54 Storage engine cost calculation 41:08 Example of engine costs in MariaDB 42:34 Things MariaDB doesn't handle well 43:40 Some reflections 47:20 Вопросы и ответы 47:35 Question 1 48:44 Question 2 50:20 Question 3 53:08 Question 4 55:18 Question 5 58:07 Question 6 01:00:26 Question 7 01:01:38 Question 8 01:02:15 Question 9 01:03:05 Question 10
SQL25-09 MariaDB’s Query Optimizer. A Multi-tool That Does Some Things Differently (Monty Widenius) 00:00 Start 00:09 Вступление 02:24 History 07:19 MariaDB's Query Optimizer 10:55 Architecture 11:55 Optimizer overview 13:05 Subquery optimizations plan 14:14 Constant tables 17:15 Range Optimizer 17:31 Range Analyzer 24:03 Range analyser output 24:26 Range analyser output (много условий) 25:40 The optimizer trace 27:01 Handling for special cases 30:35 Optimizer cost 30:48 Optimizer redesign in MariaDB 11.0 36:43 Different storage engine costs 38:54 Storage engine cost calculation 41:08 Example of engine costs in MariaDB 42:34 Things MariaDB doesn't handle well 43:40 Some reflections 47:20 Вопросы и ответы 47:35 Question 1 48:44 Question 2 50:20 Question 3 53:08 Question 4 55:18 Question 5 58:07 Question 6 01:00:26 Question 7 01:01:38 Question 8 01:02:15 Question 9 01:03:05 Question 10