This three-part series is your starting point for tuning your system for power efficiency. In Part 3, the author compares the performance of the five in-kernel governors in both tuned and untuned states to show you how to optimize a Linux-based System x server.

MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently.

In the first piece in this series we looked at the role schedulers play in I/O optimization. But how do you actually select and tune a scheduler to increase I/O performance in practice?

Get an introduction to swap (paging) space, learn how to configure and administer it, capture statistics, and tune your Virtual Memory Manager (VMM) settings to provide for optimum swap (paging) space configuration and performance.

The most important aspect of webserver performance is the amount of available RAM. This means that as you set up your server it is important to prevent the server from using the swap file as this will dramatically slow down the server.

This three-part series is your starting point for tuning your system for power efficiency. In Part 1, get up to speed on the components and concepts you need to fine-tune a Linux-based System x server for power efficiency.

Each tuning is almost unique. We show postgresql.conf file for 9.1 version as a starting point on Debian GNU/Linux systems.

These examples were deployed for a given major query profile, discovered using PgFouine.

In Part 3, the author compares the performance of the five in-kernel governors in both tuned and untuned states to show you how to optimize a Linux-based System x server.

Simple partition resizing operations, such as those described in Part 1 of this series, usually conclude successfully. Sometimes, though, you need to do something different or troubleshoot problems. This article covers some of these situations.