Это пробный урок. Оформите подписку, чтобы получить доступ ко всем материалам курса. Премиум

  1. Урок 1. 00:02:02
    Query Execution Basics
  2. Урок 2. 00:02:33
    Utility Layer
  3. Урок 3. 00:04:26
    SQL Layer
  4. Урок 4. 00:02:03
    Storage Engine Layer
  5. Урок 5. 00:00:30
    Conclusions
  6. Урок 6. 00:04:11
    Making use of Performance Schema
  7. Урок 7. 00:03:33
    Top 10 Time-Consuming Queries
  8. Урок 8. 00:01:30
    Why Are Queries Slow?
  9. Урок 9. 00:02:37
    Finding Candidate Queries for Optimization
  10. Урок 10. 00:01:45
    Table I/O and File I/O for Selects
  11. Урок 11. 00:03:34
    Table I/O and File I/O for Updates and Deletes
  12. Урок 12. 00:01:41
    The Error Summary Tables
  13. Урок 13. 00:00:37
    Conclusions
  14. Урок 14. 00:02:12
    How does the Optimiser work?
  15. Урок 15. 00:01:34
    EXPLAIN basics
  16. Урок 16. 00:02:36
    Example 1: Single Table, Table Scan
  17. Урок 17. 00:01:13
    EXPLAIN ANALYZE
  18. Урок 18. 00:00:43
    Example 2: Single Table, Index Access
  19. Урок 19. 00:00:59
    Example 3: Multicolumn Index
  20. Урок 20. 00:01:55
    Example 4: Two Tables With Subquery And Sorting
  21. Урок 21. 00:04:42
    Spotting jumps in runtime
  22. Урок 22. 00:00:51
    Hot and cold cache behaviour
  23. Урок 23. 00:00:39
    Conclusions
  24. Урок 24. 00:00:53
    Section Overview
  25. Урок 25. 00:01:02
    The Clustered Indexes
  26. Урок 26. 00:03:44
    Choosing a Good Primary Key
  27. Урок 27. 00:05:04
    Use Case: Inserting rows in primary key order with InnoDB
  28. Урок 28. 00:01:42
    Optimal Primary Key in Practice
  29. Урок 29. 00:04:37
    Introduction
  30. Урок 30. 00:03:47
    Why add a Secondary Index?
  31. Урок 31. 00:02:14
    When should you Add or Remove Indexes?
  32. Урок 32. 00:02:07
    Why Index Statistics are Important?
  33. Урок 33. 00:04:22
    How to help MySQL make better decisions?
  34. Урок 34. 00:03:38
    Covering Indexes
  35. Урок 35. 00:01:52
    Motivation
  36. Урок 36. 00:02:00
    Columns Order
  37. Урок 37. 00:05:07
    Composite Index Hands-on
  38. Урок 38. 00:04:53
    Using Redundant Indexes
  39. Урок 39. 00:01:52
    Composite Indexes Extra Remarks
  40. Урок 40. 00:00:31
    Conclusions
  41. Урок 41. 00:04:44
    Configuration Best Practices
  42. Урок 42. 00:02:56
    InnoDB Overview
  43. Урок 43. 00:03:49
    Adjusting the Buffer Pool Size
  44. Урок 44. 00:02:06
    Adding more Buffer Pool Instances
  45. Урок 45. 00:01:09
    Why Dumping the Buffer Pool?
  46. Урок 46. 00:02:47
    Tuning Flushing Pages Process
  47. Урок 47. 00:01:51
    Tuning Redo Log Buffer
  48. Урок 48. 00:03:03
    Tuning Redo Log Files
  49. Урок 49. 00:01:29
    Parallel Query Execution
  50. Урок 50. 00:02:00
    Adjusting the Query Buffers
  51. Урок 51. 00:00:56
    Conclusions
  52. Урок 52. 00:01:07
    Impact of Transactions
  53. Урок 53. 00:03:45
    Managing Locks
  54. Урок 54. 00:02:22
    Purpose of Undo Logs
  55. Урок 55. 00:02:02
    Reduce Locking - Transaction size and age
  56. Урок 56. 00:01:48
    Reduce Locking - Indexes
  57. Урок 57. 00:03:51
    Reduce Locking - Transaction Isolation Levels
  58. Урок 58. 00:01:46
    Monitoring Transactions
  59. Урок 59. 00:00:48
    Monitoring Locks
  60. Урок 60. 00:00:58
    Conclusions
  61. Урок 61. 00:00:50
    Scaling MySQL Intro
  62. Урок 62. 00:02:31
    Read Versus Write Loads
  63. Урок 63. 00:03:38
    Replication - Scaling Reads with Read Pools
  64. Урок 64. 00:02:23
    Replication - Service Discovery for Read Pools
  65. Урок 65. 00:02:36
    Queuing
  66. Урок 66. 00:03:28
    Sharding Introduction
  67. Урок 67. 00:04:06
    Sharding Concerns
  68. Урок 68. 00:03:16
    How to Partition Data in MySQL
  69. Урок 69. 00:01:57
    Multiple Partitioning Keys
  70. Урок 70. 00:01:29
    Querying Across Shards