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

Search results for High Performance MySQL

Unix+clones

High Performance MySQL

Post date: December 1, 2006, 04:12 Category: Optimizing Views: 5835 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.
Linux

MySQLTuner - Performance Tunning MySQL on Linux

Post date: January 24, 2010, 06:01 Category: Optimizing Views: 4339 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.
Linux

Check Your Mysql Server Performance with MySQLTuner

Post date: November 30, 2008, 20:11 Category: Software Views: 2769 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.
Openfiler

Installing and Configuring Openfiler with DRBD and Heartbeat

Post date: October 26, 2008, 13:10 Category: Installing Views: 11444 Comments
Tutorial quote: Openfiler is a high performance operating system tailored for use as a SAN/NAS appliance. This configuration will enable two Openfiler appliances to work in an active/passive high availability scenario.
Unix+clones

Using MySQL to benchmark OS performance

Post date: April 12, 2005, 07:04 Category: Benchmarks Views: 3509 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
Unix+clones

Considerations for the system architect: Performance

Post date: April 20, 2005, 10:04 Category: Miscellaneous Views: 2889 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.
Unix+clones

Comparing MySQL performance

Post date: April 12, 2005, 07:04 Category: Benchmarks Views: 3427 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.
Fedora

Installing Nginx With PHP5 And MySQL Support On Fedora 12

Post date: February 7, 2010, 12:02 Category: Installing Views: 2673 Comments
Tutorial quote: Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 12 server with PHP5 support (through FastCGI) and MySQL support.
Fedora

Installing Nginx With PHP5 And MySQL Support On Fedora 13

Post date: July 27, 2010, 11:07 Category: Installing Views: 2564 Comments
Tutorial quote: Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 13 server with PHP5 support (through FastCGI) and MySQL support.
OpenSUSE

Installing Nginx With PHP5 And MySQL Support On OpenSUSE 11.3

Post date: August 10, 2010, 15:08 Category: Installing Views: 2947 Comments
Tutorial quote: Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an OpenSUSE 11.3 server with PHP5 support (through FastCGI) and MySQL support.
Web-based applications and online marketing solutions - LumoLink