MySQL performance analysis on a limited resource server
Mohiuddin Ahmed, Mohammad Moshee Uddin, Saiful Azad, Shariq Haseeb · 2010
MySQL is the most successful database system being used all over the world especially when small and medium size industries are trying to cut costs. In this paper, some performance matrices are evaluated for MySQL server and benchmark tests done on two different types of Linux distributions, Fedora and Ubuntu. For performance comparison, a low specification server is used to find out whether it can handle moderately loaded (such as SMEs) MySQL transactions. The paper evaluates the performance differences by tweaking some parameters of SysBench and measure the network, CPU performance, memory and database query time. The paper also analyzes the results and attempt to find out the reasons of performance variations.