Other
[ FreeCourseWeb com ] Udemy - MySQL High Performance Tuning Guide
-
-
- Rate this torrent + | -
Download Anonymously! Get Protected Today And Get your 70% discount
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 722.76 MB) (Files: 217)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. MySQL Architecture
1. Query Execution Basics.mp4
1. Query Execution Basics.srt
2. Query Execution Basics.html
3. Utility Layer.mp4
3. Utility Layer.srt
4. Utility Layer.html
5. SQL Layer.mp4
5. SQL Layer.srt
6. SQL Layer.html
7. Storage Engine Layer.mp4
7. Storage Engine Layer.srt
8. Storage Engine Layer.html
9. Conclusions.mp4
9. Conclusions.srt
2. Spotting Query Problems
1. Example Databases.html
1.1 Example Databases.html
10. Table IO and File IO for Selects.html
11. Table IO and File IO for Updates and Deletes.mp4
11. Table IO and File IO for Updates and Deletes.srt
11.1 IO_Updates.sql.html
12. Table IO and File IO for Updates and Deletes.html
13. The Error Summary Tables.mp4
13. The Error Summary Tables.srt
13.1 error_summary.sql.html
14. Conclusions.mp4
14. Conclusions.srt
2. Making use of Performance Schema.mp4
2. Making use of Performance Schema.srt
2.1 perf_schema.sql.html
3. Making use of Performance Schema.html
4. Top 10 Time-Consuming Queries.mp4
4. Top 10 Time-Consuming Queries.srt
4.1 top_10_time_consuming_queries.sql.html
5. Top 10 Time-Consuming Queries.html
6. Why Are Queries Slow.mp4
6. Why Are Queries Slow.srt
7. Finding Candidate Queries for Optimization.mp4
7. Finding Candidate Queries for Optimization.srt
7.1 cand_query_optimization.sql.html
8. Finding Candidate Queries for Optimization.html
9. Table IO and File IO for Selects.mp4
9. Table IO and File IO for Selects.srt
9.1 IO_Selects.sql.html
sakila-db
sakila-data.sql
sakila-schema.sql
sakila.mwb
world.sql
3. Analyzing Queries
1. How does the Optimiser work.mp4
1. How does the Optimiser work.srt
10. Example 3 Multicolumn Index.mp4
10. Example 3 Multicolumn Index.srt
11. Example 4 Two Tables With Subquery And Sorting.mp4
11. Example 4 Two Tables With Subquery And Sorting.srt
12. Spotting jumps in runtime.mp4
12. Spotting jumps in runtime.srt
13. Spotting jumps in runtime.html
14. Hot and cold cache behaviour.mp4
14. Hot and cold cache behaviour.srt
15. Conclusions.mp4
15. Conclusions.srt
2. How does the Optimiser work.html
3. EXPLAIN basics.mp4
3. EXPLAIN basics.srt
4. EXPLAIN basics.html
5. Example 1 Single Table, Table Scan.mp4
5. Example 1 Single Table, Table Scan.srt
6. Example 1 Single Table, Table Scan.html
7. EXPLAIN ANALYZE.mp4
7. EXPLAIN ANALYZE.srt
8. EXPLAIN ANALYZE.html
9. Example 2 Single Table, Index Access.mp4
9. Example 2 Single Table, Index Access.srt
4. The Clustered Index and Choosing the Primary Key
1. Section Overview.mp4
1. Section Overview.srt
2. The Clustered Indexes.mp4
2. The Clustered Indexes.srt
3. The Clustered Indexes.html
4. Choosing a Good Primary Key.mp4
4. Choosing a Good Primary Key.srt
5. Choosing a Good Primary Key.html
6. Use Case Inserting rows in primary key order with InnoDB.mp4
6. Use Case Inserting rows in primary key order with InnoDB.srt
6.1 choosing_primary_key.py.html
6.2 choosing_primary_key.sql.html
7. Use Case Inserting rows in primary key order with InnoDB.html
8. Optimal Primary Key in Practice.mp4
8. Optimal Primary Key in Practice.srt
9. Optimal Primary Key in Practice.html
5. Indexing for Performance
1. Introduction.mp4
1. Introduction.srt
10. Covering Indexes.mp4
10. Covering Indexes.srt
10.1 covering_indexes.sql.html
11. Covering Indexes.html
2. Why add a Secondary Index.mp4
2. Why add a Secondary Index.srt
2.1 secondary_indexes.sql.html
3. Why add a Secondary Index.html
4. When should you Add or Remove Indexes.mp4
4. When should you Add or Remove Indexes.srt
5. When should you Add or Remove Indexes.html
6. Why Index Statistics are Important.mp4
6. Why Index Statistics are Important.srt
7. Why Index Statistics are Important.html
8. How to help MySQL make better decisions.mp4
8. How to help MySQL make better decisions.srt
9. How to help MySQL make better decisions.html
6. MySQL Composite Index
1. Motivation.mp4
1. Motivation.srt
10. Conclusions.mp4
10. Conclusions.srt
2. Motivation.html
3. Columns Order.mp4
3. Columns Order.srt
4. Columns Order.html
5. Composite Index Hands-on.mp4
5. Composite Index Hands-on.srt
5.1 composite_indexes.py.html
5.2 composite_indexes.sql.html
6. Using Redundant Indexes.mp4
6. Using Redundant Indexes.srt
7. Using Redundant Indexes.html
8. Composite Indexes Extra Remarks.mp4
8. Composite Indexes Extra Remarks.srt
9. Composite Indexes Extra Remarks.html
7. MySQL Configuration
1. Configuration Best Practices.mp4
1. Configuration Best Practices.srt
10. Dumping the Buffer Pool.html
11. Tuning Flushing Pages Process.mp4
11. Tuning Flushing Pages Process.srt
11.1 io_capacity_flushing_pages.sql.html
12. Flushing Pages.html
13. Tuning Redo Log Buffer.mp4
13. Tuning Redo Log Buffer.srt
14. The Redo Log Buffer.html
15. Tuning Redo Log Files.mp4
15. Tuning Redo Log Files.srt
15.1 redo_logs_configurations.sql.html
16. The Redo Log Files.html
17. Parallel Query Execution.mp4
17. Parallel Query Execution.srt
17.1 parallel_query_execution.sql.html
18. Parallel Query Execution.html
19. Adjusting the Query Buffers.mp4
19. Adjusting the Query Buffers.srt
2. Configuration Best Practices.html
20. Query Buffers.html
21. Conclusions.mp4
21. Conclusions.srt
3. InnoDB Overview.mp4
3. InnoDB Overview.srt
4. InnoDB Overview.html
5. Adjusting the Buffer Pool Size.mp4
5. Adjusting the Buffer Pool Size.srt
5.1 buffer_pool_size.sql.html
6. Buffer Pool Size.html
7. Adding more Buffer Pool Instances.mp4
7. Adding more Buffer Pool Instances.srt
8. Buffer Pool Instances.html
9. Why Dumping the Buffer Pool.mp4
9. Why Dumping the Buffer Pool.srt
8. MySQL Transactions and Locks
1. Impact of Transactions.mp4
1. Impact of Transactions.srt
10. Reduce Locking - Indexes.html
11. Reduce Locking - Transaction Isolation Levels.mp4
11. Reduce Locking - Transaction Isolation Levels.srt
12. Reduce Locking - Transaction Isolation Levels.html
13. Monitoring Transactions.mp4
13. Monitoring Transactions.srt
14. Monitoring Transactions.html
15. Monitoring Locks.mp4
15. Monitoring Locks.srt
16. Monitoring Locks.html
17. Conclusions.mp4
17. Conclusions.srt
2. Impact of Transactions.html
3. Managing Locks.mp4
3. Managing Locks.srt
4. Managing Locks.html
5. Purpose of Undo Logs.mp4
5. Purpose of Undo Logs.srt
6. Purpose of Undo Logs.html
7. Reduce Locking - Transaction size and age.mp4
7. Reduce Locking - Transaction size and age.srt
8. Reduce Locking - Transaction size and age.html
9. Reduce Locking - Indexes.mp4
9. Reduce Locking - Indexes.srt
9. Fundamental Concepts for Scaling MySQL
1. Scaling MySQL Intro.mp4
1. Scaling MySQL Intro.srt
10. Sharding Introduction.mp4
10. Sharding Introduction.srt
11. Sharding Introduction.html
12. Sharding Concerns.mp4
12. Sharding Concerns.srt
13. Sharding Concerns.html
14. How to Partition Data in MySQL.mp4
14. How to Partition Data in MySQL.srt
15. How to Partition Data in MySQL.html
16. Multiple Partitioning Keys.mp4
16. Multiple Partitioning Keys.srt
17. Multiple Partitioning Keys.html
18. Querying Across Shards.mp4
18. Querying Across Shards.srt
2. Read Versus Write Loads.mp4
2. Read Versus Write Loads.srt
3. Read Versus Write Loads.html
4. Replication - Scaling Reads with Read Pools.mp4
4. Replication - Scaling Reads with Read Pools.srt
5. Replication - Scaling Reads with Read Pools.html
6. Replication - Service Discovery for Read Pools.mp4
6. Replication - Service Discovery for Read Pools.srt
7. Replication - Service Discovery for Read Pools.html
8. Queuing.mp4
8. Queuing.srt
9. Queuing.html
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ FreeCourseWeb com ] Udemy - MySQL High Performance Tuning Guide Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
