Abstract
The intent of the project is to study the MySQL design limitations and tradeoffs; and produce a solution of how to tackle these limitations and tradeoffs. Thereby improving the efficiency of the MySQL queries and making the system fast. The goal of the project is to show how we can reduce the query timing by using benchmarking while we are creating a database and also by following specific optimization rules to get more efficient output in less time. Trying to work on these limitations and finding an alternate will help improve the efficiency of MySQL as a whole. The project is based on benchmarking, which is intended to measure the runtime performance of scalar expressions; it has some significant implications for the way that it is used and also the way the results are interpreted. Benchmarking is done on the application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing it with a “dummy” module), we can proceed to identifying the next bottleneck. Even if the overall performance of the application is currently acceptable, we need to at least make a plan for each bottleneck and decide how to solve it.