MySQL Optimization / Repair Information

How MySQL Uses Memory
This page lists some of the ways that the mysqld server uses memory, and associated mysqld variable names
Memory Use MySQL 5.0
Memory Use MySQL 4.1

MySQL Optimization which covers:
- Optimization Overview
- Optimizing SELECT and Other Statements
- Locking Issues
- Optimizing Database Structure
- Optimizing the MySQL Server
- Disk Issues
Optimization MySQL 5.0
Optimization MySQL 4.1

MySQL Server Variables - SQL layer or Storage Engine specific.
List some of the more common variables as well as a brief description
Go to article 1


Optimizing the mysqld variables by Ian Gilfillan
Great article on MySQL optimization, including some guidelines on what you should set mysqld server variable too.
(key_buffer_size, Query cache variables, table_cache, sort_buffer, etc..)
Go to article

Repairing Database Corruption in MySQL by Ian Gilfillan
Table corruption should be rare when using MySQL, however it helps to know how to fix the problem when it does occur.
Go to article

Optimizing MySQL: Queries and Indexes by Ian Gilfillan
The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on "upgrading" to some other system, when the problem is really that MySQL is simply not being used properly. Badly defined or non-existent indexes are one of the primary reasons for poor performance, and fixing these can often lead to phenomenal improvements.
Go to article

Other MySQL Articles by Ian Gilfillan

  • 137 Users Found This Useful
Was this answer helpful?

Related Articles

How do I backup MySQL in Linux?

1. Copying from the mysql directoryBy default, MySQL databases on servers that use Linux are...

What is my root password for MySQL?

If the server was auto provisioned with MySQL then the root password is the same as the...

How many MySQL databases can I create?

In all our Hosting plans, you can create Unlimited MySQL Databases.

How to install Mysql

How to install Mysql Via RPM : Please check the following link and get RPM...

Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...