MySQL Optimization / Repair Information

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


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

    • Related Articles

    • Repairing MySQL tables that will not open

      This should be handled on a case by case basis, but if you are using the default MySQL table type of MyISAM (which is the default storage engine unless changed or specified differently) here are a few options: The myisamchk utility can be run from a ...

    • What is the best online resource for information about MySQL?

      The MySQL website has a complete reference manual with search capabilities available on their website: http://dev.mysql.com/doc/. The manual covers everything from basic installation, SQL syntax, to advanced usage like replication and clustering. ...

    • What are the contact delivery and optimization tools

      Learn more about our Contact Delivery and Optimization Tools and how they will help you to get the most out of your account. Delivery The Contact Delivery and Optimization Tools features go beyond just access to the marketing tools. They are an ...

    • Mysql Basic Commands

      [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create database [databasename]; List all databases on the sql server. show databases; Switch to a database. use [db name]; To see all the tables in the db. show tables; ...

    • 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 monitor just like the UNIX utility 'top' that specifically looks at what the MySQL server is doing. It updates every few seconds so you can get a reasonable ...