Skip navigation links

The world's most popular open source database

Login | Register

Developer Zone
Downloads
Documentation

MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
MySQL Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents
  - MySQL 5.7 Manual
  - MySQL 5.6 Manual
  - MySQL 5.5 Manual
  - MySQL 5.1 Manual
  - MySQL 5.0 Manual
  - MySQL 3.23/4.0/4.1 Manual

Search manual:

MySQL 3.23, 4.0, 4.1 Reference Manual :: 7 Optimization :: 7.5 Buffering and Caching

« 7.4.4 MyISAM Index Statistics Collection

7.5.1 The MyISAM Key Cache »

Section Navigation [Toggle]

7 Optimization
7.1 Optimization Overview
7.2 Obtaining Query Execution Plan Information
7.3 Optimizing SQL Statements
7.4 Optimization and Indexes
7.5 Buffering and Caching
7.6 Locking Issues
7.7 Optimizing Database Structure
7.8 Optimizing the MySQL Server
7.9 Disk Issues
7.10 Using Symbolic Links
7.11 Examining Thread Information

7.5. Buffering and Caching

7.5.1. The MyISAM Key Cache
7.5.2. The InnoDB Buffer Pool
7.5.3. The MySQL Query Cache

MySQL uses several strategies that cache information in memory buffers to increase performance.

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

Developer Zone
Documentation
Developer Articles
News & Events
Forums
Lists
Bugs
Worklog
Planet MySQL
Labs

Downloads
MySQL Community Server
MySQL Proxy
MySQL Cluster
MySQL Workbench
MySQL Connectors
Archives

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster
Other Documents
About
Archives

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2013, Oracle Corporation and/or its affiliates