Skip navigation links

Browse

Ask the Librarian

Note the above only searches this section, for site searches use the overall search function. Help: Searching, Tag Searching

The MySQL Librarian collects the best of the web when it comes to MySQL! If you have something to add to the Librarian, please do so. Help us keep it current and relevant to the MySQL Community!

Browser Tools

  • Bookmarklet: Add to Librarian
    Drag link above to your browser (Firefox/Safari) toolbar to add URLs to the MySQL Librarian from anywhere.

Profile

Top Voted (Last Month)

  1. Does MySQL support Julian Dates? Vote!
Articles
Giuseppe Maxia: MySQL 5.1 partitions in practice
Add to My Link Library +2 Vote Up -0Vote Down
posted by Sakila The Librarian on Tue 14 Jul 2009 14:54 UTC
Tags:
(edit) mysql, partitions, partitioning, performance, 5.1, benchmark, Testing
This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions. The test database uses data published by the US Bureau of Transportation Statistics. Currently, the data consists of ~ 113 million records (7.5 GB data + 5.2 GB index).
Tags:
(edit) mysql, partitions, partitioning, performance, 5.1, benchmark, Testing



Report this link: