[ FreeCourseWeb.com ] Udemy - MySQL High Performance Tuning Guide

File Name

Size

Get Bonus Downloads Here.url

183 B

~Get Your Files Here !/1. MySQL Architecture/1. Query Execution Basics.mp4

10 MB

~Get Your Files Here !/1. MySQL Architecture/1. Query Execution Basics.srt

2.5 kB

~Get Your Files Here !/1. MySQL Architecture/2. Query Execution Basics.html

190 B

~Get Your Files Here !/1. MySQL Architecture/3. Utility Layer.mp4

8.9 MB

~Get Your Files Here !/1. MySQL Architecture/3. Utility Layer.srt

3.4 kB

~Get Your Files Here !/1. MySQL Architecture/4. Utility Layer.html

190 B

~Get Your Files Here !/1. MySQL Architecture/5. SQL Layer.mp4

17 MB

~Get Your Files Here !/1. MySQL Architecture/5. SQL Layer.srt

5.6 kB

~Get Your Files Here !/1. MySQL Architecture/6. SQL Layer.html

190 B

~Get Your Files Here !/1. MySQL Architecture/7. Storage Engine Layer.mp4

7.5 MB

~Get Your Files Here !/1. MySQL Architecture/7. Storage Engine Layer.srt

2.6 kB

~Get Your Files Here !/1. MySQL Architecture/8. Storage Engine Layer.html

190 B

~Get Your Files Here !/1. MySQL Architecture/9. Conclusions.mp4

2.1 MB

~Get Your Files Here !/1. MySQL Architecture/9. Conclusions.srt

589 B

~Get Your Files Here !/2. Spotting Query Problems/1. Example Databases.html

1.4 kB

~Get Your Files Here !/2. Spotting Query Problems/1.1 Example Databases.html

103 B

~Get Your Files Here !/2. Spotting Query Problems/10. Table IO and File IO for Selects.html

190 B

~Get Your Files Here !/2. Spotting Query Problems/11. Table IO and File IO for Updates and Deletes.mp4

16 MB

~Get Your Files Here !/2. Spotting Query Problems/11. Table IO and File IO for Updates and Deletes.srt

3.8 kB

~Get Your Files Here !/2. Spotting Query Problems/11.1 IO_Updates.sql.html

127 B

~Get Your Files Here !/2. Spotting Query Problems/12. Table IO and File IO for Updates and Deletes.html

190 B

~Get Your Files Here !/2. Spotting Query Problems/13. The Error Summary Tables.mp4

6.6 MB

~Get Your Files Here !/2. Spotting Query Problems/13. The Error Summary Tables.srt

1.8 kB

~Get Your Files Here !/2. Spotting Query Problems/13.1 error_summary.sql.html

130 B

~Get Your Files Here !/2. Spotting Query Problems/14. Conclusions.mp4

1.6 MB

~Get Your Files Here !/2. Spotting Query Problems/14. Conclusions.srt

707 B

~Get Your Files Here !/2. Spotting Query Problems/2. Making use of Performance Schema.mp4

22 MB

~Get Your Files Here !/2. Spotting Query Problems/2. Making use of Performance Schema.srt

5.2 kB

~Get Your Files Here !/2. Spotting Query Problems/2.1 perf_schema.sql.html

128 B

~Get Your Files Here !/2. Spotting Query Problems/3. Making use of Performance Schema.html

190 B

~Get Your Files Here !/2. Spotting Query Problems/4. Top 10 Time-Consuming Queries.mp4

8.4 MB

~Get Your Files Here !/2. Spotting Query Problems/4. Top 10 Time-Consuming Queries.srt

4.4 kB

~Get Your Files Here !/2. Spotting Query Problems/4.1 top_10_time_consuming_queries.sql.html

146 B

~Get Your Files Here !/2. Spotting Query Problems/5. Top 10 Time-Consuming Queries.html

190 B

~Get Your Files Here !/2. Spotting Query Problems/6. Why Are Queries Slow.mp4

5.5 MB

~Get Your Files Here !/2. Spotting Query Problems/6. Why Are Queries Slow.srt

1.9 kB

~Get Your Files Here !/2. Spotting Query Problems/7. Finding Candidate Queries for Optimization.mp4

14 MB

~Get Your Files Here !/2. Spotting Query Problems/7. Finding Candidate Queries for Optimization.srt

2.9 kB

~Get Your Files Here !/2. Spotting Query Problems/7.1 cand_query_optimization.sql.html

140 B

~Get Your Files Here !/2. Spotting Query Problems/8. Finding Candidate Queries for Optimization.html

190 B

~Get Your Files Here !/2. Spotting Query Problems/9. Table IO and File IO for Selects.mp4

9.0 MB

~Get Your Files Here !/2. Spotting Query Problems/9. Table IO and File IO for Selects.srt

2.2 kB

~Get Your Files Here !/2. Spotting Query Problems/9.1 IO_Selects.sql.html

127 B

~Get Your Files Here !/2. Spotting Query Problems/sakila-db/sakila-data.sql

3.2 MB

~Get Your Files Here !/2. Spotting Query Problems/sakila-db/sakila-schema.sql

24 kB

~Get Your Files Here !/2. Spotting Query Problems/sakila-db/sakila.mwb

39 kB

~Get Your Files Here !/2. Spotting Query Problems/world.sql

389 kB

~Get Your Files Here !/3. Analyzing Queries/1. How does the Optimiser work.mp4

8.8 MB

~Get Your Files Here !/3. Analyzing Queries/1. How does the Optimiser work.srt

2.9 kB

~Get Your Files Here !/3. Analyzing Queries/10. Example 3 Multicolumn Index.mp4

4.9 MB

~Get Your Files Here !/3. Analyzing Queries/10. Example 3 Multicolumn Index.srt

1.1 kB

~Get Your Files Here !/3. Analyzing Queries/11. Example 4 Two Tables With Subquery And Sorting.mp4

12 MB

~Get Your Files Here !/3. Analyzing Queries/11. Example 4 Two Tables With Subquery And Sorting.srt

2.4 kB

~Get Your Files Here !/3. Analyzing Queries/12. Spotting jumps in runtime.mp4

23 MB

~Get Your Files Here !/3. Analyzing Queries/12. Spotting jumps in runtime.srt

5.0 kB

~Get Your Files Here !/3. Analyzing Queries/13. Spotting jumps in runtime.html

190 B

~Get Your Files Here !/3. Analyzing Queries/14. Hot and cold cache behaviour.mp4

2.5 MB

~Get Your Files Here !/3. Analyzing Queries/14. Hot and cold cache behaviour.srt

1.0 kB

~Get Your Files Here !/3. Analyzing Queries/15. Conclusions.mp4

1.6 MB

~Get Your Files Here !/3. Analyzing Queries/15. Conclusions.srt

766 B

~Get Your Files Here !/3. Analyzing Queries/2. How does the Optimiser work.html

190 B

~Get Your Files Here !/3. Analyzing Queries/3. EXPLAIN basics.mp4

5.0 MB

~Get Your Files Here !/3. Analyzing Queries/3. EXPLAIN basics.srt

2.0 kB

~Get Your Files Here !/3. Analyzing Queries/4. EXPLAIN basics.html

190 B

~Get Your Files Here !/3. Analyzing Queries/5. Example 1 Single Table, Table Scan.mp4

8.9 MB

~Get Your Files Here !/3. Analyzing Queries/5. Example 1 Single Table, Table Scan.srt

3.3 kB

~Get Your Files Here !/3. Analyzing Queries/6. Example 1 Single Table, Table Scan.html

190 B

~Get Your Files Here !/3. Analyzing Queries/7. EXPLAIN ANALYZE.mp4

4.8 MB

~Get Your Files Here !/3. Analyzing Queries/7. EXPLAIN ANALYZE.srt

1.6 kB

~Get Your Files Here !/3. Analyzing Queries/8. EXPLAIN ANALYZE.html

190 B

~Get Your Files Here !/3. Analyzing Queries/9. Example 2 Single Table, Index Access.mp4

3.0 MB

~Get Your Files Here !/3. Analyzing Queries/9. Example 2 Single Table, Index Access.srt

883 B

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/1. Section Overview.mp4

3.3 MB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/1. Section Overview.srt

1.1 kB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/2. The Clustered Indexes.mp4

5.7 MB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/2. The Clustered Indexes.srt

1.4 kB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/3. The Clustered Indexes.html

190 B

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/4. Choosing a Good Primary Key.mp4

6.9 MB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/4. Choosing a Good Primary Key.srt

4.8 kB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/5. Choosing a Good Primary Key.html

190 B

~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

20 MB

~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

6.0 kB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/6.1 choosing_primary_key.py.html

136 B

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/6.2 choosing_primary_key.sql.html

137 B

~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

190 B

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/8. Optimal Primary Key in Practice.mp4

5.6 MB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/8. Optimal Primary Key in Practice.srt

2.1 kB

~Get Your Files Here !/4. The Clustered Index and Choosing the Primary Key/9. Optimal Primary Key in Practice.html

190 B

~Get Your Files Here !/5. Indexing for Performance/1. Introduction.mp4

10 MB

~Get Your Files Here !/5. Indexing for Performance/1. Introduction.srt

1.1 kB

~Get Your Files Here !/5. Indexing for Performance/10. Covering Indexes.mp4

14 MB

~Get Your Files Here !/5. Indexing for Performance/10. Covering Indexes.srt

4.2 kB

~Get Your Files Here !/5. Indexing for Performance/10.1 covering_indexes.sql.html

133 B

~Get Your Files Here !/5. Indexing for Performance/11. Covering Indexes.html

190 B

~Get Your Files Here !/5. Indexing for Performance/2. Why add a Secondary Index.mp4

16 MB

~Get Your Files Here !/5. Indexing for Performance/2. Why add a Secondary Index.srt

3.8 kB

~Get Your Files Here !/5. Indexing for Performance/2.1 secondary_indexes.sql.html

134 B

~Get Your Files Here !/5. Indexing for Performance/3. Why add a Secondary Index.html

190 B

~Get Your Files Here !/5. Indexing for Performance/4. When should you Add or Remove Indexes.mp4

13 MB

~Get Your Files Here !/5. Indexing for Performance/4. When should you Add or Remove Indexes.srt

2.5 kB

~Get Your Files Here !/5. Indexing for Performance/5. When should you Add or Remove Indexes.html

190 B

~Get Your Files Here !/5. Indexing for Performance/6. Why Index Statistics are Important.mp4

9.2 MB

~Get Your Files Here !/5. Indexing for Performance/6. Why Index Statistics are Important.srt

2.7 kB

~Get Your Files Here !/5. Indexing for Performance/7. Why Index Statistics are Important.html

190 B

~Get Your Files Here !/5. Indexing for Performance/8. How to help MySQL make better decisions.mp4

19 MB

~Get Your Files Here !/5. Indexing for Performance/8. How to help MySQL make better decisions.srt

5.1 kB

~Get Your Files Here !/5. Indexing for Performance/9. How to help MySQL make better decisions.html

190 B

~Get Your Files Here !/6. MySQL Composite Index/1. Motivation.mp4

7.7 MB

~Get Your Files Here !/6. MySQL Composite Index/1. Motivation.srt

2.3 kB

~Get Your Files Here !/6. MySQL Composite Index/10. Conclusions.mp4

2.1 MB

~Get Your Files Here !/6. MySQL Composite Index/10. Conclusions.srt

627 B

~Get Your Files Here !/6. MySQL Composite Index/2. Motivation.html

190 B

~Get Your Files Here !/6. MySQL Composite Index/3. Columns Order.mp4

9.8 MB

~Get Your Files Here !/6. MySQL Composite Index/3. Columns Order.srt

2.5 kB

~Get Your Files Here !/6. MySQL Composite Index/4. Columns Order.html

190 B

~Get Your Files Here !/6. MySQL Composite Index/5. Composite Index Hands-on.mp4

32 MB

~Get Your Files Here !/6. MySQL Composite Index/5. Composite Index Hands-on.srt

4.2 kB

~Get Your Files Here !/6. MySQL Composite Index/5.1 composite_indexes.py.html

133 B

~Get Your Files Here !/6. MySQL Composite Index/5.2 composite_indexes.sql.html

134 B

~Get Your Files Here !/6. MySQL Composite Index/6. Using Redundant Indexes.mp4

21 MB

~Get Your Files Here !/6. MySQL Composite Index/6. Using Redundant Indexes.srt

5.3 kB

~Get Your Files Here !/6. MySQL Composite Index/7. Using Redundant Indexes.html

190 B

~Get Your Files Here !/6. MySQL Composite Index/8. Composite Indexes Extra Remarks.mp4

6.7 MB

~Get Your Files Here !/6. MySQL Composite Index/8. Composite Indexes Extra Remarks.srt

2.1 kB

~Get Your Files Here !/6. MySQL Composite Index/9. Composite Indexes Extra Remarks.html

190 B

~Get Your Files Here !/7. MySQL Configuration/1. Configuration Best Practices.mp4

17 MB

~Get Your Files Here !/7. MySQL Configuration/1. Configuration Best Practices.srt

6.0 kB

~Get Your Files Here !/7. MySQL Configuration/10. Dumping the Buffer Pool.html

190 B

~Get Your Files Here !/7. MySQL Configuration/11. Tuning Flushing Pages Process.mp4

13 MB

~Get Your Files Here !/7. MySQL Configuration/11. Tuning Flushing Pages Process.srt

3.2 kB

~Get Your Files Here !/7. MySQL Configuration/11.1 io_capacity_flushing_pages.sql.html

143 B

~Get Your Files Here !/7. MySQL Configuration/12. Flushing Pages.html

190 B

~Get Your Files Here !/7. MySQL Configuration/13. Tuning Redo Log Buffer.mp4

30 MB

~Get Your Files Here !/7. MySQL Configuration/13. Tuning Redo Log Buffer.srt

8.1 kB

~Get Your Files Here !/7. MySQL Configuration/14. The Redo Log Buffer.html

190 B

~Get Your Files Here !/7. MySQL Configuration/15. Tuning Redo Log Files.mp4

11 MB

~Get Your Files Here !/7. MySQL Configuration/15. Tuning Redo Log Files.srt

2.8 kB

~Get Your Files Here !/7. MySQL Configuration/15.1 redo_logs_configurations.sql.html

141 B

~Get Your Files Here !/7. MySQL Configuration/16. The Redo Log Files.html

190 B

~Get Your Files Here !/7. MySQL Configuration/17. Parallel Query Execution.mp4

4.0 MB

~Get Your Files Here !/7. MySQL Configuration/17. Parallel Query Execution.srt

1.7 kB

~Get Your Files Here !/7. MySQL Configuration/17.1 parallel_query_execution.sql.html

141 B

~Get Your Files Here !/7. MySQL Configuration/18. Parallel Query Execution.html

190 B

~Get Your Files Here !/7. MySQL Configuration/19. Adjusting the Query Buffers.mp4

7.5 MB

~Get Your Files Here !/7. MySQL Configuration/19. Adjusting the Query Buffers.srt

2.5 kB

~Get Your Files Here !/7. MySQL Configuration/2. Configuration Best Practices.html

190 B

~Get Your Files Here !/7. MySQL Configuration/20. Query Buffers.html

190 B

~Get Your Files Here !/7. MySQL Configuration/21. Conclusions.mp4

3.5 MB

~Get Your Files Here !/7. MySQL Configuration/21. Conclusions.srt

1.1 kB

~Get Your Files Here !/7. MySQL Configuration/3. InnoDB Overview.mp4

16 MB

~Get Your Files Here !/7. MySQL Configuration/3. InnoDB Overview.srt

3.7 kB

~Get Your Files Here !/7. MySQL Configuration/4. InnoDB Overview.html

190 B

~Get Your Files Here !/7. MySQL Configuration/5. Adjusting the Buffer Pool Size.mp4

7.0 MB

~Get Your Files Here !/7. MySQL Configuration/5. Adjusting the Buffer Pool Size.srt

4.1 kB

~Get Your Files Here !/7. MySQL Configuration/5.1 buffer_pool_size.sql.html

133 B

~Get Your Files Here !/7. MySQL Configuration/6. Buffer Pool Size.html

190 B

~Get Your Files Here !/7. MySQL Configuration/7. Adding more Buffer Pool Instances.mp4

14 MB

~Get Your Files Here !/7. MySQL Configuration/7. Adding more Buffer Pool Instances.srt

2.4 kB

~Get Your Files Here !/7. MySQL Configuration/8. Buffer Pool Instances.html

190 B

~Get Your Files Here !/7. MySQL Configuration/9. Why Dumping the Buffer Pool.mp4

7.4 MB

~Get Your Files Here !/7. MySQL Configuration/9. Why Dumping the Buffer Pool.srt

1.3 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/1. Impact of Transactions.mp4

3.0 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/1. Impact of Transactions.srt

1.3 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/10. Reduce Locking - Indexes.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/11. Reduce Locking - Transaction Isolation Levels.mp4

13 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/11. Reduce Locking - Transaction Isolation Levels.srt

3.6 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/12. Reduce Locking - Transaction Isolation Levels.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/13. Monitoring Transactions.mp4

6.9 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/13. Monitoring Transactions.srt

2.0 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/14. Monitoring Transactions.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/15. Monitoring Locks.mp4

4.9 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/15. Monitoring Locks.srt

817 B

~Get Your Files Here !/8. MySQL Transactions and Locks/16. Monitoring Locks.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/17. Conclusions.mp4

2.8 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/17. Conclusions.srt

1.2 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/2. Impact of Transactions.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/3. Managing Locks.mp4

14 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/3. Managing Locks.srt

4.6 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/4. Managing Locks.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/5. Purpose of Undo Logs.mp4

22 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/5. Purpose of Undo Logs.srt

3.0 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/6. Purpose of Undo Logs.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/7. Reduce Locking - Transaction size and age.mp4

6.3 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/7. Reduce Locking - Transaction size and age.srt

2.5 kB

~Get Your Files Here !/8. MySQL Transactions and Locks/8. Reduce Locking - Transaction size and age.html

190 B

~Get Your Files Here !/8. MySQL Transactions and Locks/9. Reduce Locking - Indexes.mp4

6.6 MB

~Get Your Files Here !/8. MySQL Transactions and Locks/9. Reduce Locking - Indexes.srt

1.5 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/1. Scaling MySQL Intro.mp4

3.1 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/1. Scaling MySQL Intro.srt

1.1 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/10. Sharding Introduction.mp4

11 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/10. Sharding Introduction.srt

4.3 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/11. Sharding Introduction.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/12. Sharding Concerns.mp4

16 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/12. Sharding Concerns.srt

4.9 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/13. Sharding Concerns.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/14. How to Partition Data in MySQL.mp4

17 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/14. How to Partition Data in MySQL.srt

3.9 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/15. How to Partition Data in MySQL.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/16. Multiple Partitioning Keys.mp4

11 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/16. Multiple Partitioning Keys.srt

2.4 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/17. Multiple Partitioning Keys.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/18. Querying Across Shards.mp4

4.4 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/18. Querying Across Shards.srt

1.9 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/2. Read Versus Write Loads.mp4

9.0 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/2. Read Versus Write Loads.srt

3.0 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/3. Read Versus Write Loads.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/4. Replication - Scaling Reads with Read Pools.mp4

14 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/4. Replication - Scaling Reads with Read Pools.srt

4.4 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/5. Replication - Scaling Reads with Read Pools.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/6. Replication - Service Discovery for Read Pools.mp4

9.3 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/6. Replication - Service Discovery for Read Pools.srt

2.8 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/7. Replication - Service Discovery for Read Pools.html

190 B

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/8. Queuing.mp4

7.2 MB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/8. Queuing.srt

3.1 kB

~Get Your Files Here !/9. Fundamental Concepts for Scaling MySQL/9. Queuing.html

190 B

~Get Your Files Here !/Bonus Resources.txt

357 B