ABSTRACT
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.
- Linda Dailey Paulson, "Open Source Databases Move into the Marketplace," Industry Trends, July 2004. Google ScholarDigital Library
- Derek J. Balling, and Jeremy Zawodny, "High Performance MySQL," Chapter 3, O'Reilly Publishing, ISBN: 0-596-00306-4, April 2004.Google Scholar
- MySQL Performance Benchmarks, Measuring MySQL's Scalability and Throughput, A MySQLTechnical White Paper, May 2005.Google Scholar
- MySQL Performance Analysis and Tuning Tips on HP-UX, Prepared By ViSolve Database Performance TeamGoogle Scholar
- A Look at MySQL 5.0 Performance Benchmarks, A MySQLTechnical White Paper, May 2006.Google Scholar
- MySQL Innodb SysBench OLTP Benchmark Test, Sun Microsystems Inc. White Paper, April 2006.Google Scholar
- Benchmark brief for MySQL database server on HP ProLiant BL480c servers, Hewlett-Packard Development Company Documents, June 2007.Google Scholar
- Sizing for MySQL database server on HP ProLiant BL35p, BL25p and BL45p servers, Hewlett-Packard Development Company Documents, Revision 2, November 2007.Google Scholar
- Sysbench manual, Available: http://sysbench.sourceforge.netGoogle Scholar
- Simple Interprocess Messaging System. Retrieved November 29th, 2009, from http://packages.ubuntu.com/hardy/dbusGoogle Scholar
- D-Bus Tutorial. Havoc Pennington. Retrieved November 29th, 2009, from http://dbus.freedesktop.org/doc/dbus-tutorial.htmlGoogle Scholar
Recommendations
A Study of Bare PC SIP Server Performance
ICSNC '10: Proceedings of the 2010 Fifth International Conference on Systems and Networks CommunicationsIn bare computing, applications run directly on an ordinary PC without using an operating system (OS). Advantages of bare PC computing include elimination of overhead due to the OS, and immunity against attacks targeting OS vulnerabilities. We evaluate ...
Multi-platform Performance Analysis for CRUD Operations in Relational Databases from Java Programs Using Hibernate
Big Data Intelligence and ComputingAbstractA data set is a collection of information about something. Almost every application nowadays needs data persistence to maintain track of its status in the event of a problem. Databases are the primary component of an application for storing data ...
Comments