Tuning Primer

Developed In: bash  — Status:  Production - GA

This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and higher (including 5.1). Moved file download and bug reporting to Launchpad 2008-06-19 22:45:13 1.4-r4 release with correction in key_buffer usage calculation 2008-01-10 10:11:40

https://launchpad.net/mysql-tuning-primer
Matthew Montgomery
The GNU General Public License (GPL)
Database Administrators
Novice
Production - GA
bash

Current Tags

bash  oksoft  performance  tuning 

You must be logged in to tag this project

On Nov 18, 2009 @ 22:32, Dmitriy Royzenberg said:

Thank you, Matthew. Very handy tool to quickly check misses in core server configuration.

On May 10, 2009 @ 04:07, Shantanu Oak said:

Really useful script. Can not work without first running it!

On Jun 18, 2008 @ 22:17, Fred Fillon said:

Thank you again for this excellent script !

On Apr 21, 2008 @ 14:08, tjohnson said:

Excellent script. Worked very well.

Votes

  • Rated 4.86 out of 5
Rated 4.86 out of 5 with 7 votes cast.
You must be logged in to vote.

Watches

10 members are watching this project
You must be logged in to track this project.

Provide Feedback

Please note:
HTML will be purified, but we allow for a number of HTML tags so that you have the flexibility to decorate your comment text to some extent. The comments allow the following HTML tags:

strong, b, em, blockquote, a, code, pre

To put code into your comment, simply encapsulate your code with
[code language="XXX"][/code], where XXX is any common language, for instance "PHP", "SQL", "C", etc.

You must be logged in to comment