Optimizing your MySQL tables
To get the best performance from your MySQL database you need to make sure you have good buffer sizes. This decreases disk IO and speeds up performance.
If you are using MyISAM tables, key_buffer_size is the one you care about. If you are using InnoDB tables, the innodb_buffer_pool_size is the one care about. The defaults tend to be pretty small, usually 8 MB or so. Increase these over time until you see your disk IO level out.
If you are using MyISAM tables, key_buffer_size is the one you care about. If you are using InnoDB tables, the innodb_buffer_pool_size is the one care about. The defaults tend to be pretty small, usually 8 MB or so. Increase these over time until you see your disk IO level out.
| Rating: | no ratings, 0 total Votes |
| Categories: | MySQL optimization databases |
| Added: | on Oct 21, 2008 at 11:18 am |
| Added By: | an anonymous user |
| Searches: | mysql database table optimization |
