📊 Database Tuning

📌 Introduction

We experiment with the different concepts of database tuning and the different techniques used like:

• Optimizing the schema.
• Optimizing the memory requirements.
• Optimizing the queries.
• Testing the performance of MySQL vs MongoDB.

📌 Database Schema



📌 Results

MySQL Performance



MySQL vs MongoDB Performance



Effects of combine all optimizations



📌 Conclusion

• Query optimization has an effect when the DBMS didn’t optimize the query and reorder the join to get min cost.

• Index the table reduces the time for selection and grouping by on the value which has the index, also when joining on the foreign key it reduces the time when there is an index.

• Increasing the buffer pool increases the number of pages cached in the buffer pool which reduces the time of the query.

📌 For more details check the report