|
|
1. Configuration Best Practices.mp4
|
MP4
|
16.9 MB
|
|
|
1. Configuration Best Practices.srt
|
SRT
|
6 KB
|
|
|
1. Example Databases.html
|
HTML
|
1.4 KB
|
|
|
1. How does the Optimiser work.mp4
|
MP4
|
8.8 MB
|
|
|
1. How does the Optimiser work.srt
|
SRT
|
2.9 KB
|
|
|
1. Impact of Transactions.mp4
|
MP4
|
3 MB
|
|
|
1. Impact of Transactions.srt
|
SRT
|
1.3 KB
|
|
|
1. Introduction.mp4
|
MP4
|
10.5 MB
|
|
|
1. Introduction.srt
|
SRT
|
1.1 KB
|
|
|
1. Motivation.mp4
|
MP4
|
7.7 MB
|
|
|
1. Motivation.srt
|
SRT
|
2.3 KB
|
|
|
1. Query Execution Basics.mp4
|
MP4
|
10.1 MB
|
|
|
1. Query Execution Basics.srt
|
SRT
|
2.5 KB
|
|
|
1. Scaling MySQL Intro.mp4
|
MP4
|
3.1 MB
|
|
|
1. Scaling MySQL Intro.srt
|
SRT
|
1.1 KB
|
|
|
1. Section Overview.mp4
|
MP4
|
3.3 MB
|
|
|
1. Section Overview.srt
|
SRT
|
1.1 KB
|
|
|
1.1 Example Databases.html
|
HTML
|
102.4 B
|
|
|
10. Conclusions.mp4
|
MP4
|
2.1 MB
|
|
|
10. Conclusions.srt
|
SRT
|
614.4 B
|
|
|
10. Covering Indexes.mp4
|
MP4
|
13.8 MB
|
|
|
10. Covering Indexes.srt
|
SRT
|
4.2 KB
|
|
|
10. Dumping the Buffer Pool.html
|
HTML
|
204.8 B
|
|
|
10. Example 3 Multicolumn Index.mp4
|
MP4
|
4.9 MB
|
|
|
10. Example 3 Multicolumn Index.srt
|
SRT
|
1.1 KB
|
|
|
10. Reduce Locking - Indexes.html
|
HTML
|
204.8 B
|
|
|
10. Sharding Introduction.mp4
|
MP4
|
11.3 MB
|
|
|
10. Sharding Introduction.srt
|
SRT
|
4.3 KB
|
|
|
10. Table IO and File IO for Selects.html
|
HTML
|
204.8 B
|
|
|
10.1 covering_indexes.sql.html
|
HTML
|
102.4 B
|
|
|
11. Covering Indexes.html
|
HTML
|
204.8 B
|
|
|
11. Example 4 Two Tables With Subquery And Sorting.mp4
|
MP4
|
12.4 MB
|
|
|
11. Example 4 Two Tables With Subquery And Sorting.srt
|
SRT
|
2.4 KB
|
|
|
11. Reduce Locking - Transaction Isolation Levels.mp4
|
MP4
|
12.7 MB
|
|
|
11. Reduce Locking - Transaction Isolation Levels.srt
|
SRT
|
3.6 KB
|
|
|
11. Sharding Introduction.html
|
HTML
|
204.8 B
|
|
|
11. Table IO and File IO for Updates and Deletes.mp4
|
MP4
|
16.2 MB
|
|
|
11. Table IO and File IO for Updates and Deletes.srt
|
SRT
|
3.8 KB
|
|
|
11. Tuning Flushing Pages Process.mp4
|
MP4
|
13.2 MB
|
|
|
11. Tuning Flushing Pages Process.srt
|
SRT
|
3.2 KB
|
|
|
11.1 IO_Updates.sql.html
|
HTML
|
102.4 B
|
|
|
11.1 io_capacity_flushing_pages.sql.html
|
HTML
|
102.4 B
|
|
|
12. Flushing Pages.html
|
HTML
|
204.8 B
|
|
|
12. Reduce Locking - Transaction Isolation Levels.html
|
HTML
|
204.8 B
|
|
|
12. Sharding Concerns.mp4
|
MP4
|
16.3 MB
|
|
|
12. Sharding Concerns.srt
|
SRT
|
4.9 KB
|
|
|
12. Spotting jumps in runtime.mp4
|
MP4
|
23 MB
|
|
|
12. Spotting jumps in runtime.srt
|
SRT
|
5 KB
|
|
|
12. Table IO and File IO for Updates and Deletes.html
|
HTML
|
204.8 B
|
|
|
13. Monitoring Transactions.mp4
|
MP4
|
6.9 MB
|
|
|
13. Monitoring Transactions.srt
|
SRT
|
2 KB
|
|
|
13. Sharding Concerns.html
|
HTML
|
204.8 B
|
|
|
13. Spotting jumps in runtime.html
|
HTML
|
204.8 B
|
|
|
13. The Error Summary Tables.mp4
|
MP4
|
6.6 MB
|
|
|
13. The Error Summary Tables.srt
|
SRT
|
1.8 KB
|
|
|
13. Tuning Redo Log Buffer.mp4
|
MP4
|
30.5 MB
|
|
|
13. Tuning Redo Log Buffer.srt
|
SRT
|
8.1 KB
|
|
|
13.1 error_summary.sql.html
|
HTML
|
102.4 B
|
|
|
14. Conclusions.mp4
|
MP4
|
1.6 MB
|
|
|
14. Conclusions.srt
|
SRT
|
716.8 B
|
|
|
14. Hot and cold cache behaviour.mp4
|
MP4
|
2.5 MB
|
|
|
14. Hot and cold cache behaviour.srt
|
SRT
|
1 KB
|
|
|
14. How to Partition Data in MySQL.mp4
|
MP4
|
17.2 MB
|
|
|
14. How to Partition Data in MySQL.srt
|
SRT
|
3.9 KB
|
|
|
14. Monitoring Transactions.html
|
HTML
|
204.8 B
|
|
|
14. The Redo Log Buffer.html
|
HTML
|
204.8 B
|
|
|
15. Conclusions.mp4
|
MP4
|
1.6 MB
|
|
|
15. Conclusions.srt
|
SRT
|
716.8 B
|
|
|
15. How to Partition Data in MySQL.html
|
HTML
|
204.8 B
|
|
|
15. Monitoring Locks.mp4
|
MP4
|
4.9 MB
|
|
|
15. Monitoring Locks.srt
|
SRT
|
819.2 B
|
|
|
15. Tuning Redo Log Files.mp4
|
MP4
|
11.4 MB
|
|
|
15. Tuning Redo Log Files.srt
|
SRT
|
2.8 KB
|
|
|
15.1 redo_logs_configurations.sql.html
|
HTML
|
102.4 B
|
|
|
16. Monitoring Locks.html
|
HTML
|
204.8 B
|
|
|
16. Multiple Partitioning Keys.mp4
|
MP4
|
10.9 MB
|
|
|
16. Multiple Partitioning Keys.srt
|
SRT
|
2.4 KB
|
|
|
16. The Redo Log Files.html
|
HTML
|
204.8 B
|
|
|
17. Conclusions.mp4
|
MP4
|
2.8 MB
|
|
|
17. Conclusions.srt
|
SRT
|
1.2 KB
|
|
|
17. Multiple Partitioning Keys.html
|
HTML
|
204.8 B
|
|
|
17. Parallel Query Execution.mp4
|
MP4
|
4 MB
|
|
|
17. Parallel Query Execution.srt
|
SRT
|
1.7 KB
|
|
|
17.1 parallel_query_execution.sql.html
|
HTML
|
102.4 B
|
|
|
18. Parallel Query Execution.html
|
HTML
|
204.8 B
|
|
|
18. Querying Across Shards.mp4
|
MP4
|
4.4 MB
|
|
|
18. Querying Across Shards.srt
|
SRT
|
1.9 KB
|
|
|
19. Adjusting the Query Buffers.mp4
|
MP4
|
7.5 MB
|
|
|
19. Adjusting the Query Buffers.srt
|
SRT
|
2.5 KB
|
|
|
2. Configuration Best Practices.html
|
HTML
|
204.8 B
|
|
|
2. How does the Optimiser work.html
|
HTML
|
204.8 B
|
|
|
2. Impact of Transactions.html
|
HTML
|
204.8 B
|
|
|
2. Making use of Performance Schema.mp4
|
MP4
|
22.3 MB
|
|
|
2. Making use of Performance Schema.srt
|
SRT
|
5.2 KB
|
|
|
2. Motivation.html
|
HTML
|
204.8 B
|
|
|
2. Query Execution Basics.html
|
HTML
|
204.8 B
|
|
|
2. Read Versus Write Loads.mp4
|
MP4
|
9 MB
|
|
|
2. Read Versus Write Loads.srt
|
SRT
|
3 KB
|
|
|
2. The Clustered Indexes.mp4
|
MP4
|
5.7 MB
|
|
|
2. The Clustered Indexes.srt
|
SRT
|
1.4 KB
|
|
|
2. Why add a Secondary Index.mp4
|
MP4
|
15.5 MB
|
|
|
2. Why add a Secondary Index.srt
|
SRT
|
3.8 KB
|
|
|
2.1 perf_schema.sql.html
|
HTML
|
102.4 B
|
|
|
2.1 secondary_indexes.sql.html
|
HTML
|
102.4 B
|
|
|
20. Query Buffers.html
|
HTML
|
204.8 B
|
|
|
21. Conclusions.mp4
|
MP4
|
3.5 MB
|
|
|
21. Conclusions.srt
|
SRT
|
1.1 KB
|
|
|
3. Columns Order.mp4
|
MP4
|
9.8 MB
|
|
|
3. Columns Order.srt
|
SRT
|
2.5 KB
|
|
|
3. EXPLAIN basics.mp4
|
MP4
|
5 MB
|
|
|
3. EXPLAIN basics.srt
|
SRT
|
2 KB
|
|
|
3. InnoDB Overview.mp4
|
MP4
|
15.9 MB
|
|
|
3. InnoDB Overview.srt
|
SRT
|
3.7 KB
|
|
|
3. Making use of Performance Schema.html
|
HTML
|
204.8 B
|
|
|
3. Managing Locks.mp4
|
MP4
|
13.8 MB
|
|
|
3. Managing Locks.srt
|
SRT
|
4.6 KB
|
|
|
3. Read Versus Write Loads.html
|
HTML
|
204.8 B
|
|
|
3. The Clustered Indexes.html
|
HTML
|
204.8 B
|
|
|
3. Utility Layer.mp4
|
MP4
|
8.9 MB
|
|
|
3. Utility Layer.srt
|
SRT
|
3.4 KB
|
|
|
3. Why add a Secondary Index.html
|
HTML
|
204.8 B
|
|
|
4. Choosing a Good Primary Key.mp4
|
MP4
|
6.9 MB
|
|
|
4. Choosing a Good Primary Key.srt
|
SRT
|
4.8 KB
|
|
|
4. Columns Order.html
|
HTML
|
204.8 B
|
|
|
4. EXPLAIN basics.html
|
HTML
|
204.8 B
|
|
|
4. InnoDB Overview.html
|
HTML
|
204.8 B
|
|
|
4. Managing Locks.html
|
HTML
|
204.8 B
|
|
|
4. Replication - Scaling Reads with Read Pools.mp4
|
MP4
|
14.5 MB
|
|
|
4. Replication - Scaling Reads with Read Pools.srt
|
SRT
|
4.4 KB
|
|
|
4. Top 10 Time-Consuming Queries.mp4
|
MP4
|
8.4 MB
|
|
|
4. Top 10 Time-Consuming Queries.srt
|
SRT
|
4.4 KB
|
|
|
4. Utility Layer.html
|
HTML
|
204.8 B
|
|
|
4. When should you Add or Remove Indexes.mp4
|
MP4
|
13.4 MB
|
|
|
4. When should you Add or Remove Indexes.srt
|
SRT
|
2.5 KB
|
|
|
4.1 top_10_time_consuming_queries.sql.html
|
HTML
|
102.4 B
|
|
|
5. Adjusting the Buffer Pool Size.mp4
|
MP4
|
7 MB
|
|
|
5. Adjusting the Buffer Pool Size.srt
|
SRT
|
4.1 KB
|
|
|
5. Choosing a Good Primary Key.html
|
HTML
|
204.8 B
|
|
|
5. Composite Index Hands-on.mp4
|
MP4
|
32.1 MB
|
|
|
5. Composite Index Hands-on.srt
|
SRT
|
4.2 KB
|
|
|
5. Example 1 Single Table, Table Scan.mp4
|
MP4
|
8.9 MB
|
|
|
5. Example 1 Single Table, Table Scan.srt
|
SRT
|
3.3 KB
|
|
|
5. Purpose of Undo Logs.mp4
|
MP4
|
21.9 MB
|
|
|
5. Purpose of Undo Logs.srt
|
SRT
|
3 KB
|
|
|
5. Replication - Scaling Reads with Read Pools.html
|
HTML
|
204.8 B
|
|
|
5. SQL Layer.mp4
|
MP4
|
17 MB
|
|
|
5. SQL Layer.srt
|
SRT
|
5.6 KB
|
|
|
5. Top 10 Time-Consuming Queries.html
|
HTML
|
204.8 B
|
|
|
5. When should you Add or Remove Indexes.html
|
HTML
|
204.8 B
|
|
|
5.1 buffer_pool_size.sql.html
|
HTML
|
102.4 B
|
|
|
5.1 composite_indexes.py.html
|
HTML
|
102.4 B
|
|
|
5.2 composite_indexes.sql.html
|
HTML
|
102.4 B
|
|
|
6. Buffer Pool Size.html
|
HTML
|
204.8 B
|
|
|
6. Example 1 Single Table, Table Scan.html
|
HTML
|
204.8 B
|
|
|
6. Purpose of Undo Logs.html
|
HTML
|
204.8 B
|
|
|
6. Replication - Service Discovery for Read Pools.mp4
|
MP4
|
9.3 MB
|
|
|
6. Replication - Service Discovery for Read Pools.srt
|
SRT
|
2.8 KB
|
|
|
6. SQL Layer.html
|
HTML
|
204.8 B
|
|
|
6. Use Case Inserting rows in primary key order with InnoDB.mp4
|
MP4
|
20.3 MB
|
|
|
6. Use Case Inserting rows in primary key order with InnoDB.srt
|
SRT
|
6 KB
|
|
|
6. Using Redundant Indexes.mp4
|
MP4
|
20.6 MB
|
|
|
6. Using Redundant Indexes.srt
|
SRT
|
5.3 KB
|
|
|
6. Why Are Queries Slow.mp4
|
MP4
|
5.5 MB
|
|
|
6. Why Are Queries Slow.srt
|
SRT
|
1.9 KB
|
|
|
6. Why Index Statistics are Important.mp4
|
MP4
|
9.2 MB
|
|
|
6. Why Index Statistics are Important.srt
|
SRT
|
2.7 KB
|
|
|
6.1 choosing_primary_key.py.html
|
HTML
|
102.4 B
|
|
|
6.2 choosing_primary_key.sql.html
|
HTML
|
102.4 B
|
|
|
7. Adding more Buffer Pool Instances.mp4
|
MP4
|
14 MB
|
|
|
7. Adding more Buffer Pool Instances.srt
|
SRT
|
2.4 KB
|
|
|
7. EXPLAIN ANALYZE.mp4
|
MP4
|
4.8 MB
|
|
|
7. EXPLAIN ANALYZE.srt
|
SRT
|
1.6 KB
|
|
|
7. Finding Candidate Queries for Optimization.mp4
|
MP4
|
13.7 MB
|
|
|
7. Finding Candidate Queries for Optimization.srt
|
SRT
|
2.9 KB
|
|
|
7. Reduce Locking - Transaction size and age.mp4
|
MP4
|
6.3 MB
|
|
|
7. Reduce Locking - Transaction size and age.srt
|
SRT
|
2.5 KB
|
|
|
7. Replication - Service Discovery for Read Pools.html
|
HTML
|
204.8 B
|
|
|
7. Storage Engine Layer.mp4
|
MP4
|
7.5 MB
|
|
|
7. Storage Engine Layer.srt
|
SRT
|
2.6 KB
|
|
|
7. Use Case Inserting rows in primary key order with InnoDB.html
|
HTML
|
204.8 B
|
|
|
7. Using Redundant Indexes.html
|
HTML
|
204.8 B
|
|
|
7. Why Index Statistics are Important.html
|
HTML
|
204.8 B
|
|
|
7.1 cand_query_optimization.sql.html
|
HTML
|
102.4 B
|
|
|
8. Buffer Pool Instances.html
|
HTML
|
204.8 B
|
|
|
8. Composite Indexes Extra Remarks.mp4
|
MP4
|
6.7 MB
|
|
|
8. Composite Indexes Extra Remarks.srt
|
SRT
|
2.1 KB
|
|
|
8. EXPLAIN ANALYZE.html
|
HTML
|
204.8 B
|
|
|
8. Finding Candidate Queries for Optimization.html
|
HTML
|
204.8 B
|
|
|
8. How to help MySQL make better decisions.mp4
|
MP4
|
18.6 MB
|
|
|
8. How to help MySQL make better decisions.srt
|
SRT
|
5.1 KB
|
|
|
8. Optimal Primary Key in Practice.mp4
|
MP4
|
5.6 MB
|
|
|
8. Optimal Primary Key in Practice.srt
|
SRT
|
2.1 KB
|
|
|
8. Queuing.mp4
|
MP4
|
7.2 MB
|
|
|
8. Queuing.srt
|
SRT
|
3.1 KB
|
|
|
8. Reduce Locking - Transaction size and age.html
|
HTML
|
204.8 B
|
|
|
8. Storage Engine Layer.html
|
HTML
|
204.8 B
|
|
|
9. Composite Indexes Extra Remarks.html
|
HTML
|
204.8 B
|
|
|
9. Conclusions.mp4
|
MP4
|
2.1 MB
|
|
|
9. Conclusions.srt
|
SRT
|
614.4 B
|
|
|
9. Example 2 Single Table, Index Access.mp4
|
MP4
|
3 MB
|
|
|
9. Example 2 Single Table, Index Access.srt
|
SRT
|
921.6 B
|
|
|
9. How to help MySQL make better decisions.html
|
HTML
|
204.8 B
|
|
|
9. Optimal Primary Key in Practice.html
|
HTML
|
204.8 B
|
|
|
9. Queuing.html
|
HTML
|
204.8 B
|
|
|
9. Reduce Locking - Indexes.mp4
|
MP4
|
6.6 MB
|
|
|
9. Reduce Locking - Indexes.srt
|
SRT
|
1.5 KB
|
|
|
9. Table IO and File IO for Selects.mp4
|
MP4
|
9 MB
|
|
|
9. Table IO and File IO for Selects.srt
|
SRT
|
2.2 KB
|
|
|
9. Why Dumping the Buffer Pool.mp4
|
MP4
|
7.4 MB
|
|
|
9. Why Dumping the Buffer Pool.srt
|
SRT
|
1.3 KB
|
|
|
9.1 IO_Selects.sql.html
|
HTML
|
102.4 B
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
sakila-data.sql
|
SQL
|
3.2 MB
|
|
|
sakila-schema.sql
|
SQL
|
23.7 KB
|
|
|
sakila.mwb
|
MWB
|
39.2 KB
|
|
|
world.sql
|
SQL
|
389.3 KB
|
