Knowledgebase

MySQL Optimization / Repair Information  Print this Article

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

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

Was this answer helpful?

Also Read

How do I backup MySQL in Linux?
1. Copying from the mysql directoryBy default, MySQL databases on servers that use Linux are...
How to install Mysql
How to install Mysql Via RPM : Please check the following link and get RPM...
What is my root password for MySQL?
If the server was auto provisioned with MySQL then the root password is the same as the...
What is the best online resource for information about MySQL?
The MySQL website has a complete reference manual with search capabilities available on their...
Securing MySQL
Due to differing needs and requirements this is difficult to answer except on a case by case...

Powered by WHMCompleteSolution