Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for Comparing MySQL performance


Comparing MySQL performance

Post date: April 12, 2005, 07:04 Category: Benchmarks Views: 3381 Comments
Tutorial quote: With the introduction of the 2.6 Linux kernel, FreeBSD-5-STABLE, Solaris 10, and now NetBSD 2.0, you might be wondering which of them offers superior database performance. In my previous article, I discussed the tools I chose to test these venerable operating systems and the methodology by which they were tested. The result is this MySQL performance comparison between OpenBSD 3.6; NetBSD 2.0; FreeBSD 5.3 and 4.10; Solaris Express (build 69); and Linux 2.4 and 2.6 (Gentoo-based). Read on for the results.

NPTL vs. NPGT vs. LinuxThreads

Post date: April 24, 2005, 09:04 Category: Benchmarks Views: 2977 Comments
Tutorial quote: Ulrich Drepper recently offered some interesting benchmark results, comparing the time it takes to create and destroy threads with different threading models under various conditions. The tests were run using a 2.5.37 development kernel, comparing LinuxThreads, NGPT 2.0.2 and NPTL 0.1.

MySQLTuner - Performance Tunning MySQL on Linux

Post date: January 24, 2010, 06:01 Category: Optimizing Views: 4272 Comments
Tutorial quote: MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

Check Your Mysql Server Performance with MySQLTuner

Post date: November 30, 2008, 20:11 Category: Software Views: 2728 Comments
Tutorial quote: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.

High Performance MySQL

Post date: December 1, 2006, 04:12 Category: Optimizing Views: 5781 Comments
Tutorial quote: The operating system your MySQL server runs on and the server's configuration can be just as important to your server's performance as the indexes, schema, or queries themselves. In this chapter, we will help you understand how to tune your server to improve performance, as opposed to tuning schema or queries. We'll be looking at changes to your hardware, operating system, and MySQL configuration to see what effects they have on overall performance.

We assume that you've already made efforts to boost the performance of your queries. If you haven't done that already, stop now and read Chapter 4 and Chapter 5 to get a handle on optimizing your queries and your application code. Only then should you worry about server settings. Hardware is often not the solution to MySQL performance problems. Poorly optimized queries can slow you down far more than not having the latest CPU or SCSI disk. To put this in perspective, one of the MySQL AB trainers even says that changing hardware might, in the best cases, give you a 10-fold performance increase. But tuning queries (and schemas) can often give you 1000-fold performance increase. Seriously.

Some topics covered in this chapter are platform-specific. The authors' knowledge of the various platforms on which MySQL runs is limited. In many cases, you'll need to consult your local documentation for various operating system tools and specifics.

We start with an overview of the factors that limit performance and then look more in depth at RAID, hardware, and operating system issues. The chapter finishes with a discussion of techniques you can use to locate, identify, and fix bottlenecks.

Using MySQL to benchmark OS performance

Post date: April 12, 2005, 07:04 Category: Benchmarks Views: 3460 Comments
Tutorial quote: It seems to be an exciting time for *nix operating systems, with a number of them recently releasing new versions that bring the addition of expanded features and claims of improved performance. If you're using GNU/Linux, OpenBSD, NetBSD, FreeBSD, or Solaris as a database server, you've probably recently considered an upgrade or switch to another OS in that list due to marketing hype and hearsay. This article will show you how to benchmark operating system performance using MySQL on these OSes so you can find out for yourself if you're missing out. While this may not necessarily be indicative of overall system performance or overall database application performance, it will tell you specifically how well MySQL performs on your platform.

The following operating systems were used for the comparison testing:
- FreeBSD 4.11
- FreeBSD 5.3
- NetBSD 2.0
- Linux 2.6
- Linux 2.4
- Solaris 10 x86 (build 69)
- OpenBSD 3.6

Considerations for the system architect: Performance

Post date: April 20, 2005, 10:04 Category: Miscellaneous Views: 2844 Comments
Tutorial quote: For many developers and engineers, performance is often an afterthought. But when a product functions as designed and has proven stability and the right feature mix, success in the marketplace often depends upon performance. Architectural decisions define the ultimate feasible performance of any product. In this article, learn how performance-monitoring technology initially developed for mainframes can help you improve your own code's performance.

Optimizing Mac OS X performance

Post date: January 18, 2006, 16:01 Category: Optimizing Views: 7008 Comments
Tutorial quote: This FAQ provides recommendations for optimizing MacĀ® OS X performance. Additionally, it provides advice and links to advice for troubleshooting certain Mac OS X performance problems.

Performance Tools for Optimizing Linux: Process-Specific CPU

Post date: June 1, 2005, 07:06 Category: Optimizing Views: 3129 Comments
Tutorial quote: The tools to analyze the performance of applications are varied and have existed in one form or another since the early days of UNIX. It is critical to understand how an application is interacting with the operating system, CPU, and memory system to understand its performance. This chapter will help you understand where the bottleneck in your system is occuring, and how to fix it.

Configuring Apache for Maximum Performance

Post date: April 1, 2006, 03:04 Category: Optimizing Views: 4279 Comments
Tutorial quote: Apache server performance can be improved by adding additional hardware resources such as RAM, faster CPU etc. But, most of the time, the same result can be achieved by custom configuration of the server. This article looks into getting maximum performance out of Apache with the existing hardware resources, specifically on the Linux systems.
Web-based applications and online marketing solutions - LumoLink