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
Go to article 2

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

  • 921 Users Found This Useful
Was this answer helpful?

Related Articles

How can I monitor what my MySQL server is doing?

A handy little Linux application called Mytop fits this just perfectly. This is a near time...

How do I backup a MySQL database?

By logging into cPanel >> Backups you can download and restore any individual MySQL...

How to reset a mySQL password?

If you have lost your root user password for MySQL, you can reset it with the following...

Repairing MySQL tables

This should be handled on a case by case basis, but if you are using the default MySQL table type...

Securing MySQL

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