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!
Showing entries 1 to 5

Tags Filter: Testing (reset)

Articles
Add to Favourites +1 Vote Up -1Vote Down
posted by Giuseppe Maxia on Thu 01 Oct 2009 11:29 UTC
Tags:
(edit) mysql, Analysis, monitoring, mysqld, ps, pid, Testing, tip
Shlomi shows a real world scenario where the naive approach to monitoring fails spectacularly.

Report link

Videos
Add to Favourites +0 Vote Up -0Vote Down
posted by Sheeri Cabral on Tue 22 Sep 2009 20:25 UTC
Tags:
(edit) Philip Stoev, Random Query Generator, mysql, mysqlconf, Testing
If You Love It, Break It: Testing MySQL with the Random Query Generator by Philip Stoev (Sun Microsystems) The description is at: http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363 Download the presentation slides (ppt) at http://assets.en.oreilly.com/1/event/21/If%20You%20Love%20It,%20Break%20It_%20Testing%20MySQL%20with%20the%20Random%20Query%20Generator%20Presentation.ppt

Report link

Articles
Add to Favourites +4 Vote Up -0Vote Down
posted by Mark Daems on Tue 18 Aug 2009 16:53 UTC
Tags:
(edit) mysql, binary, community, download, snapshot, Testing
MySQL now provides server snapshots (nightly builds). What criteria do they meet? What should they be used for? This article clearly explains.

Report link

Articles
Add to Favourites +1 Vote Up -0Vote Down
posted by Giuseppe Maxia on Tue 18 Aug 2009 16:01 UTC
Tags:
(edit) mysql, plugin, community, innodb, Testing, 5.1, snapshot
MySQL 5.1.38 includes the InnoDB plugin. This article shows how to install the plugin, using MySQL Sandbox and the binary snapshots.

Report link

Articles
Add to Favourites +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).

Report link

Showing entries 1 to 5