[ ] Udemy - MySQL High Performance Tuning Guide 收录时间:2021-09-30 02:55:50 文件大小:723MB 下载次数:1 最近下载:2021-09-30 02:55:50 磁力链接: magnet:?xt=urn:btih:4a7c252b7a78387b745df7f8f629024c113bb4bd 立即下载 复制链接 文件列表 ~Get Your Files Here !/6. MySQL Composite Index/5. Composite Index Hands-on.mp4 32MB ~Get Your Files Here !/7. MySQL Configuration/13. Tuning Redo Log Buffer.mp4 31MB ~Get Your Files Here !/3. Analyzing Queries/12. Spotting jumps in runtime.mp4 23MB ~Get Your Files Here !/2. Spotting Query Problems/2. Making use of Performance Schema.mp4 22MB ~Get Your Files Here !/8. MySQL Transactions and Locks/5. Purpose of Undo Logs.mp4 22MB ~Get Your Files Here !/6. MySQL Composite Index/6. Using Redundant Indexes.mp4 21MB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/6. Use Case Inserting rows in primary key order with InnoDB.mp4 20MB ~Get Your Files Here !/5. Indexing for Performance/8. How to help MySQL make better decisions.mp4 19MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/14. How to Partition Data in MySQL.mp4 17MB ~Get Your Files Here !/1. MySQL Architecture/5. SQL Layer.mp4 17MB ~Get Your Files Here !/7. MySQL Configuration/1. Configuration Best Practices.mp4 17MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/12. Sharding Concerns.mp4 16MB ~Get Your Files Here !/2. Spotting Query Problems/11. Table IO and File IO for Updates and Deletes.mp4 16MB ~Get Your Files Here !/7. MySQL Configuration/3. InnoDB Overview.mp4 16MB ~Get Your Files Here !/5. Indexing for Performance/2. Why add a Secondary Index.mp4 16MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/4. Replication - Scaling Reads with Read Pools.mp4 14MB ~Get Your Files Here !/7. MySQL Configuration/7. Adding more Buffer Pool Instances.mp4 14MB ~Get Your Files Here !/5. Indexing for Performance/10. Covering Indexes.mp4 14MB ~Get Your Files Here !/8. MySQL Transactions and Locks/3. Managing Locks.mp4 14MB ~Get Your Files Here !/2. Spotting Query Problems/7. Finding Candidate Queries for Optimization.mp4 14MB ~Get Your Files Here !/5. Indexing for Performance/4. When should you Add or Remove Indexes.mp4 13MB ~Get Your Files Here !/7. MySQL Configuration/11. Tuning Flushing Pages Process.mp4 13MB ~Get Your Files Here !/8. MySQL Transactions and Locks/11. Reduce Locking - Transaction Isolation Levels.mp4 13MB ~Get Your Files Here !/3. Analyzing Queries/11. Example 4 Two Tables With Subquery And Sorting.mp4 12MB ~Get Your Files Here !/7. MySQL Configuration/15. Tuning Redo Log Files.mp4 11MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/10. Sharding Introduction.mp4 11MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/16. Multiple Partitioning Keys.mp4 11MB ~Get Your Files Here !/5. Indexing for Performance/1. Introduction.mp4 10MB ~Get Your Files Here !/1. MySQL Architecture/1. Query Execution Basics.mp4 10MB ~Get Your Files Here !/6. MySQL Composite Index/3. Columns Order.mp4 10MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/6. Replication - Service Discovery for Read Pools.mp4 9MB ~Get Your Files Here !/5. Indexing for Performance/6. Why Index Statistics are Important.mp4 9MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/2. Read Versus Write Loads.mp4 9MB ~Get Your Files Here !/2. Spotting Query Problems/9. Table IO and File IO for Selects.mp4 9MB ~Get Your Files Here !/1. MySQL Architecture/3. Utility Layer.mp4 9MB ~Get Your Files Here !/3. Analyzing Queries/5. Example 1 Single Table, Table Scan.mp4 9MB ~Get Your Files Here !/3. Analyzing Queries/1. How does the Optimiser work.mp4 9MB ~Get Your Files Here !/2. Spotting Query Problems/4. Top 10 Time-Consuming Queries.mp4 8MB ~Get Your Files Here !/6. MySQL Composite Index/1. Motivation.mp4 8MB ~Get Your Files Here !/1. MySQL Architecture/7. Storage Engine Layer.mp4 8MB ~Get Your Files Here !/7. MySQL Configuration/19. Adjusting the Query Buffers.mp4 7MB ~Get Your Files Here !/7. MySQL Configuration/9. Why Dumping the Buffer Pool.mp4 7MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/8. Queuing.mp4 7MB ~Get Your Files Here !/7. MySQL Configuration/5. Adjusting the Buffer Pool Size.mp4 7MB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/4. Choosing a Good Primary Key.mp4 7MB ~Get Your Files Here !/8. MySQL Transactions and Locks/13. Monitoring Transactions.mp4 7MB ~Get Your Files Here !/6. MySQL Composite Index/8. Composite Indexes Extra Remarks.mp4 7MB ~Get Your Files Here !/8. MySQL Transactions and Locks/9. Reduce Locking - Indexes.mp4 7MB ~Get Your Files Here !/2. Spotting Query Problems/13. The Error Summary Tables.mp4 7MB ~Get Your Files Here !/8. MySQL Transactions and Locks/7. Reduce Locking - Transaction size and age.mp4 6MB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/2. The Clustered Indexes.mp4 6MB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/8. Optimal Primary Key in Practice.mp4 6MB ~Get Your Files Here !/2. Spotting Query Problems/6. Why Are Queries Slow.mp4 6MB ~Get Your Files Here !/3. Analyzing Queries/3. EXPLAIN basics.mp4 5MB ~Get Your Files Here !/8. MySQL Transactions and Locks/15. Monitoring Locks.mp4 5MB ~Get Your Files Here !/3. Analyzing Queries/10. Example 3 Multicolumn Index.mp4 5MB ~Get Your Files Here !/3. Analyzing Queries/7. EXPLAIN ANALYZE.mp4 5MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/18. Querying Across Shards.mp4 4MB ~Get Your Files Here !/7. MySQL Configuration/17. Parallel Query Execution.mp4 4MB ~Get Your Files Here !/7. MySQL Configuration/21. Conclusions.mp4 4MB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/1. Section Overview.mp4 3MB ~Get Your Files Here !/2. Spotting Query Problems/sakila-db/sakila-data.sql 3MB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/1. Scaling MySQL Intro.mp4 3MB ~Get Your Files Here !/8. MySQL Transactions and Locks/1. Impact of Transactions.mp4 3MB ~Get Your Files Here !/3. Analyzing Queries/9. Example 2 Single Table, Index Access.mp4 3MB ~Get Your Files Here !/8. MySQL Transactions and Locks/17. Conclusions.mp4 3MB ~Get Your Files Here !/3. Analyzing Queries/14. Hot and cold cache behaviour.mp4 3MB ~Get Your Files Here !/6. MySQL Composite Index/10. Conclusions.mp4 2MB ~Get Your Files Here !/1. MySQL Architecture/9. Conclusions.mp4 2MB ~Get Your Files Here !/2. Spotting Query Problems/14. Conclusions.mp4 2MB ~Get Your Files Here !/3. Analyzing Queries/15. Conclusions.mp4 2MB ~Get Your Files Here !/2. Spotting Query Problems/world.sql 389KB ~Get Your Files Here !/2. Spotting Query Problems/sakila-db/sakila.mwb 39KB ~Get Your Files Here !/2. Spotting Query Problems/sakila-db/sakila-schema.sql 24KB ~Get Your Files Here !/7. MySQL Configuration/13. Tuning Redo Log Buffer.srt 8KB ~Get Your Files Here !/7. MySQL Configuration/1. Configuration Best Practices.srt 6KB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/6. Use Case Inserting rows in primary key order with InnoDB.srt 6KB ~Get Your Files Here !/1. MySQL Architecture/5. SQL Layer.srt 6KB ~Get Your Files Here !/6. MySQL Composite Index/6. Using Redundant Indexes.srt 5KB ~Get Your Files Here !/2. Spotting Query Problems/2. Making use of Performance Schema.srt 5KB ~Get Your Files Here !/5. Indexing for Performance/8. How to help MySQL make better decisions.srt 5KB ~Get Your Files Here !/3. Analyzing Queries/12. Spotting jumps in runtime.srt 5KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/12. Sharding Concerns.srt 5KB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/4. Choosing a Good Primary Key.srt 5KB ~Get Your Files Here !/8. MySQL Transactions and Locks/3. Managing Locks.srt 5KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/4. Replication - Scaling Reads with Read Pools.srt 4KB ~Get Your Files Here !/2. Spotting Query Problems/4. Top 10 Time-Consuming Queries.srt 4KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/10. Sharding Introduction.srt 4KB ~Get Your Files Here !/6. MySQL Composite Index/5. Composite Index Hands-on.srt 4KB ~Get Your Files Here !/5. Indexing for Performance/10. Covering Indexes.srt 4KB ~Get Your Files Here !/7. MySQL Configuration/5. Adjusting the Buffer Pool Size.srt 4KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/14. How to Partition Data in MySQL.srt 4KB ~Get Your Files Here !/2. Spotting Query Problems/11. Table IO and File IO for Updates and Deletes.srt 4KB ~Get Your Files Here !/5. Indexing for Performance/2. Why add a Secondary Index.srt 4KB ~Get Your Files Here !/7. MySQL Configuration/3. InnoDB Overview.srt 4KB ~Get Your Files Here !/8. MySQL Transactions and Locks/11. Reduce Locking - Transaction Isolation Levels.srt 4KB ~Get Your Files Here !/1. MySQL Architecture/3. Utility Layer.srt 3KB ~Get Your Files Here !/3. Analyzing Queries/5. Example 1 Single Table, Table Scan.srt 3KB ~Get Your Files Here !/7. MySQL Configuration/11. Tuning Flushing Pages Process.srt 3KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/8. Queuing.srt 3KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/2. Read Versus Write Loads.srt 3KB ~Get Your Files Here !/8. MySQL Transactions and Locks/5. Purpose of Undo Logs.srt 3KB ~Get Your Files Here !/3. Analyzing Queries/1. How does the Optimiser work.srt 3KB ~Get Your Files Here !/2. Spotting Query Problems/7. Finding Candidate Queries for Optimization.srt 3KB ~Get Your Files Here !/7. MySQL Configuration/15. Tuning Redo Log Files.srt 3KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/6. Replication - Service Discovery for Read Pools.srt 3KB ~Get Your Files Here !/5. Indexing for Performance/6. Why Index Statistics are Important.srt 3KB ~Get Your Files Here !/1. MySQL Architecture/7. Storage Engine Layer.srt 3KB ~Get Your Files Here !/8. MySQL Transactions and Locks/7. Reduce Locking - Transaction size and age.srt 3KB ~Get Your Files Here !/6. MySQL Composite Index/3. Columns Order.srt 3KB ~Get Your Files Here !/7. MySQL Configuration/19. Adjusting the Query Buffers.srt 3KB ~Get Your Files Here !/1. MySQL Architecture/1. Query Execution Basics.srt 3KB ~Get Your Files Here !/5. Indexing for Performance/4. When should you Add or Remove Indexes.srt 2KB ~Get Your Files Here !/3. Analyzing Queries/11. Example 4 Two Tables With Subquery And Sorting.srt 2KB ~Get Your Files Here !/7. MySQL Configuration/7. Adding more Buffer Pool Instances.srt 2KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/16. Multiple Partitioning Keys.srt 2KB ~Get Your Files Here !/6. MySQL Composite Index/1. Motivation.srt 2KB ~Get Your Files Here !/2. Spotting Query Problems/9. Table IO and File IO for Selects.srt 2KB ~Get Your Files Here !/6. MySQL Composite Index/8. Composite Indexes Extra Remarks.srt 2KB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/8. Optimal Primary Key in Practice.srt 2KB ~Get Your Files Here !/8. MySQL Transactions and Locks/13. Monitoring Transactions.srt 2KB ~Get Your Files Here !/3. Analyzing Queries/3. EXPLAIN basics.srt 2KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/18. Querying Across Shards.srt 2KB ~Get Your Files Here !/2. Spotting Query Problems/6. Why Are Queries Slow.srt 2KB ~Get Your Files Here !/2. Spotting Query Problems/13. The Error Summary Tables.srt 2KB ~Get Your Files Here !/7. MySQL Configuration/17. Parallel Query Execution.srt 2KB ~Get Your Files Here !/3. Analyzing Queries/7. EXPLAIN ANALYZE.srt 2KB ~Get Your Files Here !/8. MySQL Transactions and Locks/9. Reduce Locking - Indexes.srt 2KB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/2. The Clustered Indexes.srt 1KB ~Get Your Files Here !/2. Spotting Query Problems/1. Example Databases.html 1KB ~Get Your Files Here !/8. MySQL Transactions and Locks/1. Impact of Transactions.srt 1KB ~Get Your Files Here !/7. MySQL Configuration/9. Why Dumping the Buffer Pool.srt 1KB ~Get Your Files Here !/8. MySQL Transactions and Locks/17. Conclusions.srt 1KB ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/1. Section Overview.srt 1KB ~Get Your Files Here !/5. Indexing for Performance/1. Introduction.srt 1KB ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/1. Scaling MySQL Intro.srt 1KB ~Get Your Files Here !/3. Analyzing Queries/10. Example 3 Multicolumn Index.srt 1KB ~Get Your Files Here !/7. MySQL Configuration/21. Conclusions.srt 1KB ~Get Your Files Here !/3. Analyzing Queries/14. Hot and cold cache behaviour.srt 1KB ~Get Your Files Here !/3. Analyzing Queries/9. Example 2 Single Table, Index Access.srt 883B ~Get Your Files Here !/8. MySQL Transactions and Locks/15. Monitoring Locks.srt 817B ~Get Your Files Here !/3. Analyzing Queries/15. Conclusions.srt 766B ~Get Your Files Here !/2. Spotting Query Problems/14. Conclusions.srt 707B ~Get Your Files Here !/6. MySQL Composite Index/10. Conclusions.srt 627B ~Get Your Files Here !/1. MySQL Architecture/9. Conclusions.srt 589B ~Get Your Files Here !/Bonus Resources.txt 357B ~Get Your Files Here !/1. MySQL Architecture/2. Query Execution Basics.html 190B ~Get Your Files Here !/1. MySQL Architecture/4. Utility Layer.html 190B ~Get Your Files Here !/1. MySQL Architecture/6. SQL Layer.html 190B ~Get Your Files Here !/1. MySQL Architecture/8. Storage Engine Layer.html 190B ~Get Your Files Here !/2. Spotting Query Problems/10. Table IO and File IO for Selects.html 190B ~Get Your Files Here !/2. Spotting Query Problems/12. Table IO and File IO for Updates and Deletes.html 190B ~Get Your Files Here !/2. Spotting Query Problems/3. Making use of Performance Schema.html 190B ~Get Your Files Here !/2. Spotting Query Problems/5. Top 10 Time-Consuming Queries.html 190B ~Get Your Files Here !/2. Spotting Query Problems/8. Finding Candidate Queries for Optimization.html 190B ~Get Your Files Here !/3. Analyzing Queries/13. Spotting jumps in runtime.html 190B ~Get Your Files Here !/3. Analyzing Queries/2. How does the Optimiser work.html 190B ~Get Your Files Here !/3. Analyzing Queries/4. EXPLAIN basics.html 190B ~Get Your Files Here !/3. Analyzing Queries/6. Example 1 Single Table, Table Scan.html 190B ~Get Your Files Here !/3. Analyzing Queries/8. EXPLAIN ANALYZE.html 190B ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/3. The Clustered Indexes.html 190B ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/5. Choosing a Good Primary Key.html 190B ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/7. Use Case Inserting rows in primary key order with InnoDB.html 190B ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/9. Optimal Primary Key in Practice.html 190B ~Get Your Files Here !/5. Indexing for Performance/11. Covering Indexes.html 190B ~Get Your Files Here !/5. Indexing for Performance/3. Why add a Secondary Index.html 190B ~Get Your Files Here !/5. Indexing for Performance/5. When should you Add or Remove Indexes.html 190B ~Get Your Files Here !/5. Indexing for Performance/7. Why Index Statistics are Important.html 190B ~Get Your Files Here !/5. Indexing for Performance/9. How to help MySQL make better decisions.html 190B ~Get Your Files Here !/6. MySQL Composite Index/2. Motivation.html 190B ~Get Your Files Here !/6. MySQL Composite Index/4. Columns Order.html 190B ~Get Your Files Here !/6. MySQL Composite Index/7. Using Redundant Indexes.html 190B ~Get Your Files Here !/6. MySQL Composite Index/9. Composite Indexes Extra Remarks.html 190B ~Get Your Files Here !/7. MySQL Configuration/10. Dumping the Buffer Pool.html 190B ~Get Your Files Here !/7. MySQL Configuration/12. Flushing Pages.html 190B ~Get Your Files Here !/7. MySQL Configuration/14. The Redo Log Buffer.html 190B ~Get Your Files Here !/7. MySQL Configuration/16. The Redo Log Files.html 190B ~Get Your Files Here !/7. MySQL Configuration/18. Parallel Query Execution.html 190B ~Get Your Files Here !/7. MySQL Configuration/2. Configuration Best Practices.html 190B ~Get Your Files Here !/7. MySQL Configuration/20. Query Buffers.html 190B ~Get Your Files Here !/7. MySQL Configuration/4. InnoDB Overview.html 190B ~Get Your Files Here !/7. MySQL Configuration/6. Buffer Pool Size.html 190B ~Get Your Files Here !/7. MySQL Configuration/8. Buffer Pool Instances.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/10. Reduce Locking - Indexes.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/12. Reduce Locking - Transaction Isolation Levels.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/14. Monitoring Transactions.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/16. Monitoring Locks.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/2. Impact of Transactions.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/4. Managing Locks.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/6. Purpose of Undo Logs.html 190B ~Get Your Files Here !/8. MySQL Transactions and Locks/8. Reduce Locking - Transaction size and age.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/11. Sharding Introduction.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/13. Sharding Concerns.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/15. How to Partition Data in MySQL.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/17. Multiple Partitioning Keys.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/3. Read Versus Write Loads.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/5. Replication - Scaling Reads with Read Pools.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/7. Replication - Service Discovery for Read Pools.html 190B ~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/9. Queuing.html 190B Get Bonus Downloads Here.url 183B ~Get Your Files Here !/2. Spotting Query Problems/4.1 top_10_time_consuming_queries.sql.html 146B ~Get Your Files Here !/7. MySQL Configuration/11.1 io_capacity_flushing_pages.sql.html 143B ~Get Your Files Here !/7. MySQL Configuration/15.1 redo_logs_configurations.sql.html 141B ~Get Your Files Here !/7. MySQL Configuration/17.1 parallel_query_execution.sql.html 141B ~Get Your Files Here !/2. Spotting Query Problems/7.1 cand_query_optimization.sql.html 140B ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/6.2 choosing_primary_key.sql.html 137B ~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/6.1 choosing_primary_key.py.html 136B ~Get Your Files Here !/5. Indexing for Performance/2.1 secondary_indexes.sql.html 134B ~Get Your Files Here !/6. MySQL Composite Index/5.2 composite_indexes.sql.html 134B ~Get Your Files Here !/5. Indexing for Performance/10.1 covering_indexes.sql.html 133B ~Get Your Files Here !/6. MySQL Composite Index/5.1 composite_indexes.py.html 133B ~Get Your Files Here !/7. MySQL Configuration/5.1 buffer_pool_size.sql.html 133B ~Get Your Files Here !/2. Spotting Query Problems/13.1 error_summary.sql.html 130B ~Get Your Files Here !/2. Spotting Query Problems/2.1 perf_schema.sql.html 128B ~Get Your Files Here !/2. Spotting Query Problems/11.1 IO_Updates.sql.html 127B ~Get Your Files Here !/2. Spotting Query Problems/9.1 IO_Selects.sql.html 127B ~Get Your Files Here !/2. Spotting Query Problems/1.1 Example Databases.html 103B