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
- mysql, mysql issue, mysql problem
- 0 Users Found This Useful
Related Articles
How to Access your Folders(Linux/Centos) using WinSCP
Guide on how to access the folders in your vps linux! This is the easiest way, First make sure...
Changing Time Zone
Changing Time Zone in Linux:1. Login to your VPS server using Putty. 2. Type the following...
To change the VPS password (WinSCP / Putty)
To change the VPS password (WinSCP/Putty) 1. Login to SSH via xShell4 (Recommended) or Putty...
How to solve Permission denied Issue in Putty
To resolve the Permission denied issue in Putty (e.g. -bash ./configure: Permission denied)Login...
MySQL Table says IN USE, but table will not repair in PHPMyAdmin
From time to time MySQL corrupts itself. This message means that your table needs repair,...
Powered by WHMCompleteSolution
