知識庫

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